Skip to content

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.

N861ZGGeneral Energy Research Group · Conroe, TXBuilt 1979 · S/N BB-493 N862HTSublett Holdings LLC · Wilmington, DEBuilt 1981 · S/N BB-800 N867SLSafeco Leasing LLC · Port Alsworth, AKS/N BB-867 N868RXAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 1985 · S/N FA-84 N873AFDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1984 · S/N BB-1200 N874SPSamaritans Purse · Boone, NCBuilt 1981 · S/N BB-874 N875DMKilo Alfa 200 LLC · Bakersfield, CABuilt 1990 · S/N BB-1354 N875SPPacific Mission Aviation · Hagatna, GUBuilt 1975 · S/N BB-86 N87699Pjh Consulting LLC · Reno, NVBuilt 1981 · S/N BB-887 N876ATTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N BB-931 N877PAPax Dei LLC · Hot Springs, ARS/N BB-1844 N877RCPlg Aviation LLC · Tucson, AZBuilt 1981 · S/N BB-978 N879TYKimmel Aviation LLC · Madison, MSBuilt 1978 · S/N BB-498 N87CFFeltus Aviation LLC · Little Rock, ARBuilt 1983 · S/N BB-1122 N87FPMillman Transportation LLC · Saint Louis, MOBuilt 1997 · S/N BB-1565 N87SALiberty Air LLC · Christiansted, VIFirst renewal noticeBuilt 1982 · S/N BB-1089 N880MBWabash Wings LLC · Fishers, INBuilt 1981 · S/N BB-928 N881MCFoothills Aviation Partners LLC · Winston Salem, NCS/N BB-1930 N882JPJpb Air LLC · Rancho Santa Fe, CABuilt 1981 · S/N BB-882 N886AWAndrew & Williamson Sales Co · San Diego, CABuilt 1986 · S/N FA110 N888ASStanislaus Food Products Co · Modesto, CABuilt 1987 · S/N FA-136 N888ETBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N BB-258 N888HJAviation Company Inc · Cheyenne, WYBuilt 1979 · S/N BB444 N888MPProbasco Mitch · Floydada, TXBuilt 1990 · S/N BB-1358 N888ZXEm Air LLC · Richland, WABuilt 1983 · S/N BB-1140 N88JHTeton Aviation Limited Liability Company · Wilson, WYBuilt 1989 · S/N BB-1331 N88MTFlight Company LLC · Rome, GABuilt 1981 · S/N BB-830 N88MYBullrock Corp · South Burlington, VTBuilt 1983 · S/N BB-1142 N88VNAt Aero LLC · Wilmington, DEBuilt 1986 · S/N BB-1250 N890VPDodson International Parts Inc · Rantoul, KSS/N BB-1116 N896CMXrp Investments LLC · Clyde, MIBuilt 1980 · S/N BB-668 N898BRElite Medical Air Transport LLC DBA · El Paso, TXBuilt 1986 · S/N BB-1255 N899SDRed Rock Aviation LLC · Dover, DEBuilt 1981 · S/N BB-776 N89MVLegacy Aviation Trust Holdings Corp Trustee · Doral, FLS/N BB-766 N89UABoard Of Trustees · Fayetteville, ARBuilt 1989 · S/N BB-1336 N8AMMraf LLC · Wilmington, DEBuilt 1977 · S/N BB-274 N8EFMcco Inc · Tuscumbia, ALBuilt 1980 · S/N BB-721 N8KBBiddulph Oldsmobile Inc · Phoenix, AZBuilt 1978 · S/N BB-446 N8NAN8na LLC · Atlantic Beach, FLBuilt 1981 · S/N BB-950 N8NXExecutive Aviation Group Inc · Saint Petersburg, FLBuilt 1980 · S/N BB-774 N901BABismarck Air Medical LLC · Bismarck, NDBuilt 1980 · S/N BB-674 N901FFFlightline Holdings II LLC · New Orleans, LABuilt 1980 · S/N BB-637 N901LMLifeflight Of Maine LLC · Bangor, MEBuilt 1999 · S/N BB-1693 N901SFSingleton Investments LLC · Menlo Park, CABuilt 2004 · S/N BB-1859 N903TWTwi Air LLC · Picayune, MSS/N BB-1822 N904DGCentral Virginia Aviation Inc · Petersburg, VAFirst renewal noticeBuilt 1983 · S/N BB-1176 N904SHSanford Medical Center · Sioux Falls, SDBuilt 1998 · S/N BB-1614 N905NDDodson International Parts Inc · Rantoul, KSS/N BB-468 N905SHSanford Medical Center · Sioux Falls, SDS/N BB-1582 N906DCHarrington Douglas R Jr · League City, TXFirst renewal noticeBuilt 1982 · S/N BB-1094

Back to AD 89-19-04 R1