Registered aircraft · 85,620

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

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:98-21-21-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:98-21-21-R1') ORDER BY n_number

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:98-21-21-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:98-21-21-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.

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:98-21-21-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:98-21-21-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N155AZCoconino County Sheriffs Office · Flagstaff, AZBuilt 1980 · S/N 18267636 N155BPooky Aviation LLC · Augusta, GABuilt 1958 · S/N D-5701 N155CHK Top J Cattle Company LLC · Eldorado, TXBuilt 1968 · S/N CE-232 N155CTOutsideloop LLC · Denver, COBuilt 1979 · S/N R18201277 N155CWPotcake Aviation LLC · Mcminnville, ORBuilt 1975 · S/N 17265697 N155DD M C Aviation LLC · Jennings, LABuilt 1954 · S/N 30701 N155DGJuliet Tango Flying Services LLC · Walnut Creek, CABuilt 1983 · S/N 21064815 N155DJCorder Farms Aviation LLC · Mcarthur, CABuilt 1966 · S/N 18257851 N155DVDunning Vineyards · Haines, ORS/N U20602985 N155EPGogoplex LLC · Wilmington, DEBuilt 1969 · S/N 27-4430 N155FRSpeed Aviation Holdings LLC · Lewes, DEBuilt 1970 · S/N TE-817 N155JAStavrides Paul · Hartsville, PABuilt 1976 · S/N TC-1993 N155JB2mec Holdings LLC · Kalispell, MTBuilt 1966 · S/N TC-1025 N155JWTcpb LLC · Lewes, DEBuilt 1975 · S/N D-9837 N155KPGlen Stone Contruction Inc · Henderson, KYFirst renewal noticeS/N 18263197 N155KTN155kt LLC · Dover, DEBuilt 1963 · S/N 21058196 N155LUnderwood Robert · Waxahachie, TXBuilt 1968 · S/N TE-467 N155LCAle & Quail Club LLC · Cheyenne, WYBuilt 1968 · S/N TE-615 N155LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842197 N155PAllman Air LLC · Blackstone, VABuilt 1956 · S/N DH-76 N155RCClark 155 LLC · Missoula, MTS/N 21064312 N155STAzimi Shahram · Hayward, CABuilt 1964 · S/N TC-651 N155VWolcott Guy R II · Gresham, ORBuilt 1952 · S/N 20949 N155WCTca Equities LLC · Advance, NCBuilt 1981 · S/N TE-1193 N155ZPennsylvania College Of Technology · Williamsport, PABuilt 1981 · S/N TJ-368 N15600Curry Dwain · Apopka, FLBuilt 1972 · S/N 28R-7335073 N15601Wisconsin Fox River Flyers · Milwaukee, WIBuilt 1972 · S/N 28-7310059 N15605Moore Wade O · Eatonville, WAS/N 28-7325112 N15607Mohn Michael A · Ventura, CABuilt 1972 · S/N 28-7325113 N1560EAmerican Airman Inc · Stony Brook, NYBuilt 1978 · S/N 17271047 N1560JShort Christopher · Pine Mountain, GABuilt 1967 · S/N 28-23964 N1560VAvp Aviation LLC · La Jolla, CABuilt 1974 · S/N 17263663 N1560WHigh Performance Aircraft Inc · El Cajon, CABuilt 1997 · S/N E-3097 N1560YPacific Integrated Handling · Tacoma, WABuilt 1994 · S/N TH-1717 N1560ZYoung James Scott · Kemah, TXBuilt 1961 · S/N D-6863 N15610Stull Christopher H · Berrien Springs, MIBuilt 1972 · S/N 28-7305097 N15612Bonnette William A · Gill, MABuilt 1972 · S/N 28-7310060 N15616Jpd Aviation LLC · Newton, NJBuilt 1972 · S/N 28-7305098 N15617Mccary Kenneth W · Mankato, KSS/N 28-7325115 N15618Bankston Dennis G · Concordia, MOBuilt 1972 · S/N 28-7325116 N15619Mrnak Andy M · Bowman, NDS/N 28-7325117 N1561BLamberton Dale F · Brush Prairie, WABuilt 1996 · S/N E-2993 N1561CDoncat LLC · Shelby, MTS/N 30261 N1561GDusky Aviation LLC · Atlanta, GABuilt 1994 · S/N E-2854 N1561LRegistered aircraftBuilt 1994 · S/N E-2856 N1561MWagner Lacy F · Mission Viejo, CABuilt 1989 · S/N CE-1374 N1561TUmanzor Daniel A · S San Fran, CABuilt 1994 · S/N CE-1777 N1561VHenkel Douglas K · Olathe, KSBuilt 1974 · S/N 17263664 N1561WEmpresas Marex Inc · Mayaguez, PRS/N TC-1445 N1561YFire Hound LLC · Springfield, ORBuilt 1962 · S/N 17249261

Back to AD 98-21-21 R1