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.

N208BCOutside In Aviation LLC · Fort Madison, IABuilt 1975 · S/N BB89 N208FDelaware Baron Leasing Partners LLC · Wilmington, DEBuilt 1981 · S/N BB-851 N20AEButler Aviation Inc · Houma, LABuilt 1981 · S/N BB827 N211LGStaggerwing Holdings LLC · Englewood, COBuilt 2000 · S/N BB-1732 N212HCHcc Air LLC · Las Vegas, NVS/N BB-1791 N212LWPf Aviation LLC · Carl Junction, MOBuilt 2001 · S/N BB-1766 N213DBMarshall Air Systems Inc · Charlotte, NCBuilt 1993 · S/N BB-1450 N213MCMcr Aviation LLC · Austin, TXBuilt 1991 · S/N FA-216 N213PHPyro Shows Equipment LLC · La Follette, TNBuilt 1979 · S/N BB-486 N214GBPterodactyl Inc · Wilmington, DEBuilt 1999 · S/N BB-1668 N214TPPlatinum Aviation LLC · Monte Sereno, CAS/N BB1855 N215HCPlane Lease Co · Minneapolis, MNS/N BB-1848 N217CMKlas-Kcoe LLC · Las Vegas, NVBuilt 1980 · S/N BB-621 N217LGStaggerwing Holdings LLC · Crystal Lake, ILBuilt 1995 · S/N BB-1501 N217MLDodson Intl Parts Inc · Rantoul, KSS/N BB739 N218DZRed Brick Summit LLC · Wilmington, DEBuilt 1981 · S/N BB-925 N218GJJaztec LLC · Ooltewah, TNBuilt 1982 · S/N BB-1013 N21BDSouthern Illinois Helicopters LLC · Marion, ILBuilt 1983 · S/N BB-1115 N21CGN21cg Leasing LLC · Ponca City, OKBuilt 1989 · S/N BB-1346 N21DELocke-Lane Aviation LLC · Statesville, NCBuilt 1976 · S/N BB-117 N21FGCalifornia Department Of Fish And Game · Sacramento, CABuilt 1981 · S/N BB-839 N220KWAirselect LLC · West Point, IABuilt 1983 · S/N BB-1120 N220RARoyal Air Freight Inc · Waterford, MIBuilt 1983 · S/N BB-1130 N220TTShannair LLC · Saint Louis, MOS/N BB-462 N220VTExec III LLC · Maineville, OHBuilt 1983 · S/N BB-1177 N221MMGordon Truck Centers Inc · Pacific, WABuilt 1988 · S/N FA-161 N222CYBlue Star Gas Fleet Services Co · Santa Rosa, CABuilt 1990 · S/N BB-1370 N222LAGrb Logistics LLC · Grapevine, TXBuilt 1978 · S/N BB-409 N223JRBierlein Aviation LLC · Midland, MIBuilt 1985 · S/N FA-45 N223MWWhiskey Tango LLC · Midland, TXBuilt 2007 · S/N BB-1967 N223RCSailfish Aviation LLC · Little Mountain, SCBuilt 1985 · S/N FA-58 N223TPAviapa LLC · Doylestown, PABuilt 1989 · S/N BB-1348 N228RCPuro Humo Aviation LLC · Miami, FLBuilt 2005 · S/N BB-1910 N22FMjsmm LLC · Santa Rosa Beach, FLS/N BB-1025 N22GSGbs Aviation LLC · Fort Worth, TXBuilt 2001 · S/N BB-1767 N22PEAdamb200 Holdings LLC · Broken Bow, OKBuilt 1994 · S/N BB-1488 N234KW405 Transportation Partners LLC · Edmond, OKBuilt 1982 · S/N BB-1065 N235LCRosado Aviation Inc · Moosic, PABuilt 1996 · S/N BB1535 N237KConquest Express LLC · Libertyville, ILBuilt 1994 · S/N BB-1481 N239JVRim Group LLC · Waterford, MIBuilt 1982 · S/N BB-1014 N23STGreensky Aviation LLC · Mountain Home, ARBuilt 1978 · S/N BB-375 N23WSDovey Air Inc · Birmingham, MIS/N BB-1143 N241PHPhi Health LLC · Tempe, AZBuilt 1984 · S/N BB-1182 N242ZAN667kt LLC · Lewes, DEBuilt 2001 · S/N BB-1761 N243AMAirmed International LLC · Birmingham, ALBuilt 2005 · S/N BB-1896 N243CKKalitta Air LLC · Ypsilanti, MIBuilt 1997 · S/N BB-1596 N246AAAir Services International Leasing LLC · Fort Lauderdale, FLBuilt 1981 · S/N BB984 N246PHPhi Health LLC · Tempe, AZBuilt 1990 · S/N BB-1373 N248PHPhi Health LLC · Tempe, AZBuilt 1998 · S/N BB-1618 N24BGVarney Aviation LLC · Bangor, MEBuilt 1982 · S/N BB-1045

Back to AD 89-19-04 R1