OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,638

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N1506PStevens John P · Hernando, FLBuilt 1954 · S/N 22-2370N1507PWagner Rickey J · Stacy, MNBuilt 1954 · S/N 22-2372N1508ARegistered aircraftS/N 20-694N150CWCleveland William L · Lander, WYS/N 18-4329N150EPGedney William · Lake George, NYBuilt 1959 · S/N 18-7087N150KSSommers Stuart S · Newberg, ORBuilt 1951 · S/N 20-678N150NHPalmer Ronald Everett Trustee · Hopkinton, NHBuilt 1983 · S/N 18-8309012N150PPBurghduff Aviation LLC · Ludlow, SDS/N 25-23N150TTowe Lannie K · Madison, ALBuilt 1953 · S/N 18-2264N150TBStevann Farms Ltd · De Witt, IABuilt 1959 · S/N 18-4303N1514AMatthews Byron Kim · Hooper, UTS/N 20-703N1516ALampart Floyd R · Lake Clear, NYBuilt 1957 · S/N 20-706N1516PRichardson Sean W · Delta Junction, AKS/N 22-2381N1517ALong Doug J · Wolf Point, MTBuilt 1951 · S/N 20-707N151AWMaples Charles K · Bonsall, CAS/N 18-7709032N1520ABush James R · Seattle, WABuilt 1951 · S/N 20-710N1522AAbbe Thomas E · Wasilla, AKBuilt 1951 · S/N 20-711N1526ACrow Robert M · Trapper Creek, AKBuilt 1951 · S/N 20-720N1526PBailey Mark T · Yelm, WAS/N 22-2391N1528PMa Ha Co Aero Corp · Ridgeville, INS/N 22-2393N1532VSutton Aviation LLC · Maunaloa, HIBuilt 1950 · S/N 18-572N1533APearson Trevor · San Ysidro, CABuilt 1951 · S/N 20-729N1533PHager John S · Big Island, VAS/N 22-2398N15344Continental Title Trust LLC Trustee · Wichita, KSS/N 15344N1534ADelta Charlie Aviation LLC · Glendale, AZS/N 20-730N1535AHerve Keith E · North Pole, AKBuilt 1951 · S/N 20-731N1536ACoughlin Edmund Timothy · Manlius, NYBuilt 1951 · S/N 20-732N1538PWassmus Justin A · Riley, MIS/N 22-2415N1539AHall Mark R · New Smyrna Beach, FLBuilt 1951 · S/N 20-735N1540AMorrill John R · Fort Bragg, CABuilt 1951 · S/N 20-748N1541PFranklin Thomas J · Benton, KSBuilt 1954 · S/N 22-2405N1542PLewis David J · Burlington, IABuilt 1954 · S/N 22-2406N1544ABrunquist Karl · Wasilla, AKS/N 20-740N1545AStein Jay A · Glyndon, MNBuilt 1951 · S/N 20-741N1545PRegistration Pending · Missoula, MTRegistration pendingBuilt 1954 · S/N 22-2409N1549ADirk Chantz M · Rapid City, SDS/N 20-752N154TKornchuk Kurt C · Wasilla, AKS/N 18-2268N1550AGifford Steven K · Buskirk, NYS/N 20-745N1551PPhillips Kris D · Cordova, AKBuilt 1954 · S/N 18-3704N1552PErickson James M · Wasilla, AKS/N 18-3705N1553MRubbert Jan D · Upham, NDBuilt 1947 · S/N 12-3125N1554PPerkins Michael D Trustee · Bigfork, MTBuilt 1954 · S/N 18-3709N15558Nighthawk Air Systems Inc · Marion, TXS/N 18-3876N1557PVlasic Steven Robert · Homer, AKBuilt 1954 · S/N 18-3711N1559PSnatchaday LLC · Carabaset Vly, MEBuilt 1954 · S/N 18-3716N1560PGoodnight James J · Salisbury, NCBuilt 1954 · S/N 18-3717N1562AHansen Jens I · Arroyo Grande, CAS/N 20-768N1563PShoemaker Tia M · Wasilla, AKBuilt 1954 · S/N 18-3722N1564PJsfm Flyers LLC · Saint Cloud, MNBuilt 1954 · S/N 18-3725N1565PPott David F · Fairbanks, AKBuilt 1954 · S/N 18-3726
Back to AD 99-01-05 R1