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.

N480BRFive Diamond Aviation Holdings LLC · Draper, UTS/N BB1355 N481HCIntermountain Medical Transport LLC · Salt Lake City, UTS/N BB-1908 N485KBravo Hotel LLC · Lewes, DEBuilt 1979 · S/N BB-485 N486ATMeo Holdings LLC · Newark, DES/N BB-1866 N487NNDakota Equipment LLC · Bismarck, NDBuilt 1995 · S/N BB-1513 N487VCOaklr LLC · New York, NYBuilt 2001 · S/N BB-1757 N48CSMattias Transport LLC · Tucson, AZBuilt 1986 · S/N BB-1247 N48CVAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1976 · S/N BB-189 N48PACbc Aviation LLC · Hayden, IDBuilt 1981 · S/N BB-996 N48QDynamic Avlease Inc · Bridgewater, VABuilt 1981 · S/N BL48 N4925TAir Services LLC · Spokane, WAS/N BB-1870 N492GPBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N BB-1326 N494MAKing Lenny LLC · Fairview Park, OHBuilt 1986 · S/N FA108 N497RBAircraft Registration Inc Trustee · KematenBuilt 1993 · S/N FA-228 N49FBFlying Bullet LLC · Grand Island, NEBuilt 1988 · S/N FA-153 N49KCBeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB-318 N49LLSilver Wing Aviation LLC · Wilmington, DEBuilt 1981 · S/N BB-843 N4QLFremont Motor Company Inc · Lander, WYBuilt 1981 · S/N BB-942 N500CRElite Medical Air Transport LLC · El Paso, TXBuilt 1980 · S/N BB-714 N500FEBeech Transportation Inc · Eden Prairie, MNBuilt 1986 · S/N BB-1212 N500HGEm Aviation Ka B200 LLC · Atlanta, GAS/N BB-1954 N500LPMeri Acquisitions LLC · Kilgore, TXS/N BB-1141 N501EBPrecision Holdings LLC · Kimberly, IDBuilt 1978 · S/N BB-422 N501HKBam Aviation LLC · Baton Rouge, LABuilt 1979 · S/N BB-565 N502APJbjp Capital Holdings LLC · Newark, DEBuilt 1984 · S/N BB-1187 N503AWCsi Aviation Inc · Albuquerque, NMBuilt 1995 · S/N BB-1514 N503JMDls Aviation LLC · Gilmer, TXBuilt 1980 · S/N BB-712 N503PWellsprings Aviation LLC · Winston Salem, NCBuilt 1979 · S/N BB-437 N503RMKa200 LLC · Jacksonville, NCBuilt 1980 · S/N BB-673 N504GFOxford Advisory Aviation LLC · Orlando, FLBuilt 1983 · S/N BB-1156 N505AWCsi 135 Division LLC · Albuquerque, NMBuilt 2001 · S/N BB-1755 N505SPN505sp LLC · Ontario, CABuilt 1996 · S/N BB-1538 N507BEM P Leasing LLC · Vermillion, MNBuilt 1980 · S/N BB-735 N507GFBallard Aviation Inc · Newton, KSBuilt 2001 · S/N BB-1778 N508SKMagnolia Logistics Of Ms LLC · Flowood, MSBuilt 1985 · S/N FA-78 N5092SGreat Plains Communications LLC · Blair, NEBuilt 2002 · S/N BB-1802 N509FPPerdue Farms Inc · Salisbury, MDS/N BB-1886 N50EDynamic Avlease Inc · Bridgewater, VABuilt 1979 · S/N BL7 N50GGN50gg Leasing LLC · Ponca City, OKBuilt 2000 · S/N BB-1728 N50KGTurbo Air Charter LLC · Boise, IDBuilt 1982 · S/N BB-1066 N50NABv Transportation LLC · Portland, ORBuilt 1995 · S/N BB1504 N50PACenterline Aviation Inc · Middletown, DEBuilt 1988 · S/N BB-1308 N50XDynamic Avlease Inc · Bridgewater, VABuilt 1985 · S/N BB-1239 N510GSAmdel Holding LLC · Houston, TXBuilt 2001 · S/N BB-1746 N511DPAir Med Services LLC · Lafayette, LABuilt 1981 · S/N BL-15 N511GAGeaux Aire LLC · Savannah, GABuilt 1993 · S/N BB1462 N511TAAir Med Services LLC · Lafayette, LABuilt 1999 · S/N BB-1660 N514TBFast Marketing Strategies LLC · Royal Oak, MDBuilt 1990 · S/N BB-1351 N519DBN519db LLC · Dover, DEBuilt 1978 · S/N BB-436 N520DDThomas Asset Group Ltd · Springtown, TXBuilt 1980 · S/N BB-738

Back to AD 89-19-04 R1