OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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.

N7437Fedorka Paul R Trustee · Soldotna, AKBuilt 1957 · S/N 18-5455N7437DM And E Ventures LLC · Pingree Grove, ILBuilt 1957 · S/N 22-5201N7438DSchofield Wayne D · Polson, MTS/N 22-5202N743RKiskaddon Luke M · Anchorage, AKBuilt 1981 · S/N 18-8109055N744United States Dept Of Agriculture Aviation · Cedar City, UTBuilt 1982 · S/N 18-8309009N7440DHibbitts Josiah B · Hartwell, GABuilt 1957 · S/N 22-5204N7442KLipper Stephen W · Griffin, GABuilt 1950 · S/N 20-353N7444DRups Adventure North LLC · Arbor Vitae, WIBuilt 1957 · S/N 22-5208N7446DNeufeld Bernie T · Dalhart, TXBuilt 1957 · S/N 22-5210N7447KNiemyjski Justin S · Franksville, WIBuilt 1950 · S/N 20-358N7449KBuehler Andrew · Eatonville, WAS/N 20-360N744CCEland Corp · Wilmington, DEBuilt 2001 · S/N 9928CCN7450KMatelski Mark T · New Berlin, WIBuilt 1950 · S/N 20-361N7451KHendry Joshua · Carthage, TNBuilt 1950 · S/N 362N7452JMcaleer John D · Molalla, ORBuilt 1960 · S/N 18-7452N7453DRomo Blaine Jeffrey · Dillingham, AKS/N 22-5219N7455DD'Amico Joseph J · Mount Ary, MDBuilt 1957 · S/N 22-5221N7457LPiper Lover LLC · Centennial, COBuilt 1975 · S/N 18-7509051N7458KMy Piper Pacer LLC · Everett, WABuilt 1950 · S/N 20-370N7459LStewart Martin J · Anchorage, AKBuilt 1975 · S/N 18-7509054N745BRMiller Judith A · Homer, AKS/N 18-7709193N746Hall Gary L · Delta Junction, AKBuilt 1964 · S/N 18-8228N7460DJohnston Stephen P · Hawley, MNBuilt 1957 · S/N 18-5776N7460LLeoni Eric D · Boulder, COBuilt 1975 · S/N 18-7509055N7460ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1965 · S/N 25-3457N7462KGoad Graham · Mcminnville, ORBuilt 1950 · S/N 20-373N7463DRaising Cain Farms Partnership · Leland, MSS/N 18-5782N7463ZTreasure Coast Soaring Club · Port Saint Lucie, FLS/N 25-3462N7464LNorth Wind Air Service LLC · Seattle, WABuilt 1975 · S/N 18-7509061N7467LNewton Darin A · Eagle River, AKBuilt 1975 · S/N 18-7509062N7468DPine George D · Tok, AKFirst renewal noticeBuilt 1957 · S/N 18-5798N7468LBumgarner Warren B Trustee · Willow, AKBuilt 1975 · S/N 18-7509063N7468ZMiller Andy D · Marana, AZS/N 253469N7469DRegistered aircraftBuilt 1957 · S/N 18-5800N7469KRegistered aircraftBuilt 1950 · S/N 20-381N7469LJames Jeffrey L · Elizabeth, WVBuilt 1974 · S/N 18-7509065N746TJSta-Kel Corp · Westbrook, MEBuilt 1956 · S/N 18-3346 (53-7746)N7470DGoundry George D · Sammamish, WABuilt 1957 · S/N 18-5801N7470ZSmith David C · Malott, WABuilt 1965 · S/N 25-3473N7471KFunckes William · Zeeland, MIBuilt 1950 · S/N 20-384N7471LRegistered aircraftBuilt 1975 · S/N 18-7509067N7472DRomann Debra A · Anchorage, AKS/N 18-5807N7473DRezzonico John · Round Hill, VABuilt 1957 · S/N 18-5808N7473KMachado Douglas M · Kenai, AKBuilt 1950 · S/N 20-387N7474DRogue Aero LLC · Grants Pass, ORS/N 18-5809N7474LNelson Travis E · Richland, MTBuilt 1975 · S/N 18-7509069N7476LGrabofsky Livestock & Grain Inc · Hogeland, MTBuilt 1975 · S/N 18-7509072N7477KStauder Greg · Galena, ILBuilt 1950 · S/N 20-391N7477LWika Gregory B · Anchorage, AKS/N 18-7509060N7478KMayes Aviation LLC · Lebanon, MOBuilt 1950 · S/N 20-392
Back to AD 99-01-05 R1