Registered aircraft · 897

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:89-19-04-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:89-19-04-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:89-19-04-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:89-19-04-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:89-19-04-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:89-19-04-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.

N18KATreetoppers II LLC · Newark, DEBuilt 1978 · S/N BB-360 N190BHJourney Aviation LLC · Brookland, ARBuilt 1981 · S/N BB-907 N190EBKar King LLC · Huntington, WVBuilt 2005 · S/N BB-1905 N190TTAcme Jet LLC · Dover, DEBuilt 1982 · S/N BB-1005 N1926A1926a LLC · Auburn, ALBuilt 1981 · S/N BB-922 N194TRExecutive Air Taxi Corp · Bismarck, NDBuilt 1983 · S/N BB-1146 N194YYTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1989 · S/N FA-194 N195ALJmds Lift LLC · Helena, MTBuilt 1986 · S/N FA-102 N196SCChickasaw Transport LLC · Santa Rosa Beach, FLBuilt 1996 · S/N BB-1525 N196ZZTj Air Holdings Inc Trustee · Wilmington, DES/N FA-196 N199MHGsg Aviation LLC · Fort Lauderdale, FLBuilt 1981 · S/N BB-855 N19MCFlying B Holdings LLC · Ozona, TXBuilt 1988 · S/N FA-167 N1HXCentralav LLC · Lake Worth, FLBuilt 1978 · S/N BB-361 N1LTWhite River Holdings LLC · Southaven, MSS/N BB-1824 N1NPNebraska Public Power District · Columbus, NES/N BB1834 N1PTWarner Aviation Properties LLC · Austin, TXBuilt 1987 · S/N FA131 N1SMStan Mcnabb Chevrolet Buick Gmc Cadillac Inc · Tullahoma, TNBuilt 2001 · S/N BB-1782 N200BTMid-South Regional Aviation LLC · Tunica, MSBuilt 1977 · S/N BB-293 N200DAGambill Aviation LLC · Shreveport, LABuilt 1982 · S/N BB-1095 N200EARegistered aircraftBuilt 1990 · S/N BB-1368 N200FMSapphire Air II LLC · Camp Hill, PABuilt 2002 · S/N BB-1794 N200GPWesley Partners II LLC · Mount Vernon, TXBuilt 1994 · S/N BB1496 N200GSNavajo Nation · Window Rock, AZS/N BB--1214 N200GWNogottie Landing Co LLC · Amarillo, TXBuilt 1979 · S/N BB-568 N200HDCooper Container Corp · Maynardville, TNBuilt 1981 · S/N BB-987 N200HKHck Aviation LLC · Jupiter, FLBuilt 2001 · S/N BB-1772 N200JLCrest Trading Company · Bakersfield, CABuilt 1975 · S/N BB-40 N200JREngelman Acres Ltd · Edinburg, TXBuilt 1983 · S/N BB-1123 N200NDNorth Dakota Department Of Transportation · Bismarck, NDBuilt 1998 · S/N BB-1612 N200NWViking Transport LLC · Saint Louis Park, MNBuilt 1999 · S/N BB-1691 N200PHPrairie Ventures Aviation LLC · Worthington, MNBuilt 1977 · S/N BB-238 N200PZBeech Transportation Inc · Eden Prairie, MNBuilt 1978 · S/N BB-410 N200RRTexas Dept Of Criminal Justice · Huntsville, TXBuilt 1987 · S/N BB-1282 N200UWTrustees Of The University Of Wyoming · Laramie, WYBuilt 1983 · S/N BB-1155 N200VAVargus Group Inc · Providence, RIBuilt 1977 · S/N BB-246 N200WBTurbo Air Charter LLC · Boise, IDS/N BB-1754 N200WPIdplane LLC · Boise, IDBuilt 1991 · S/N BB-1393 N200WXMorales J Mark Trustee · Corpus Christi, TXBuilt 1979 · S/N BB-680 N200XCTvpx Ars Inc Trustee · North Salt Lake, UTS/N BB-1061 N202FFBeech Transportation Inc · Eden Prairie, MNBuilt 2001 · S/N BB-1786 N202NDNorth Dakota Department Of Transportation · Bismarck, NDBuilt 1998 · S/N BB1611 N203DHGuardian Flight LLC · Lewisville, TXS/N BB-1845 N203TASouthwest Aviation Specialties LLC · Tulsa, OKS/N BB-658 N204JTBarbaro Enterprises LLC · Argyle, TXBuilt 1997 · S/N BB1563 N204TPW & W Innovative Enterprises LLC · Douglas, GABuilt 1976 · S/N BB-115 N205EJLynch Flying Service Inc DBA · Billings, MTBuilt 1998 · S/N BB-1634 N205SPState Of Colorado · Englewood, COS/N BB-1826 N205TMSmitty'S Supply Inc · Roseland, LABuilt 2007 · S/N BB-1991 N206PRidgeaire Inc · Jacksonville, TXBuilt 1979 · S/N BB-466 N207HBState Of Washington · Olympia, WABuilt 1995 · S/N BB-1516

Back to AD 89-19-04 R1