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.

N806KMMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1981 · S/N BB990 N806LWSac Wild LLC · Loomis, CABuilt 1994 · S/N BB-1494 N806WBCircle I Air LLC · Lubbock, TXBuilt 1982 · S/N BB-1047 N807SMAurora Air Partners LLC · Portland, ORBuilt 2007 · S/N BB-1989 N808BESkyfall Aviation LLC · Blacksburg, VABuilt 1988 · S/N BB-1312 N809HCCourson Oil And Gas Inc · Perryton, TXS/N BB-1864 N809PSP & P Air LLC · Wilmington, DEBuilt 1978 · S/N BB-339 N80BZMiddle Tennessee State University · Murfreesboro, TNS/N FA-117 N80CPBf Air LLC · Panama City, FLBuilt 1977 · S/N BB-263 N80WMAt Aero LLC · Wilmington, DES/N BB-863 N81Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-16 N810TCSanborn Map Co Inc · Colorado Springs, COBuilt 1984 · S/N FA-002 N812TTBranched Oak Charter LLC · Rising City, NEBuilt 1985 · S/N BB-1207 N816BSN811kc LLC · Sunrise, FLBuilt 1992 · S/N BB-1440 N817BAZane Bennett Galleries LLC · Santa Fe, NMBuilt 1981 · S/N BB956 N818FWPelican Aircraft Inc · Wilmington, DEBuilt 1991 · S/N BB-1394 N81ETRussell Timothy Lee Jr · Saint Petersburg, FLBuilt 1998 · S/N BB1625 N81TFA P A C LLC · Berlin, NJBuilt 1980 · S/N BB-750 N81TLC S & P Rocky Mountain Inc · Cheyenne, WYS/N BB-959 N820DLEs&E Aviation LLC · Greensboro, NCS/N BB-1820 N825KASav Aviation LLC · Jacksonville, TXS/N BB-825 N825STLowcountry Aviation Co Brokerage LLC · Walterboro, SCBuilt 1989 · S/N BB-1320 N826WGSibi LLC · Indianapolis, INBuilt 2000 · S/N BB-1710 N827DLGa Ventures LLC · Scott, LABuilt 1986 · S/N FA-103 N828SSSusanaire LLC · Dallas, TXBuilt 1986 · S/N BB-1252 N829MCKidd Johnston Aviation LLC · Odessa, TXBuilt 2000 · S/N BB-1708 N83Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-18 N831MWKdm Ltd · Santa Teresa, NMS/N BB-1850 N831WPVagus Group Inc · Wilmington, DEBuilt 1979 · S/N BB-569 N838PSNocom Aviation LLC · Stratford, TXBuilt 1983 · S/N BB-1084 N83FTR E E Inc · Beaumont, TXBuilt 1998 · S/N BB-1621 N83KACcs Enterprises LLC · Maryville, TNBuilt 1983 · S/N BB-1111 N83PWMotion Skies LLC · Rocky Mount, NCBuilt 1987 · S/N BB-1283 N84Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-19 N841KYPinaire Holdings LLC · Hendersonville, TNS/N BB-841 N843BCA To Z Aviation LLC · Paradise Valley, AZS/N BB-1011 N846BEM D Airways Inc · Derby, KSBuilt 1984 · S/N FA-16 N847BABeech Transportation Inc · Eden Prairie, MNBuilt 1981 · S/N BB847 N84CANeojet N84ca LLC · Reno, NVBuilt 1976 · S/N BB-166 N84PCAviation Enterprises LLC · Longwood, FLBuilt 1981 · S/N BB-860 N84XPF B T Services LLC · Portland, ORBuilt 1979 · S/N BB481 N850BKRpm Consulting LLC · Middletown, DEBuilt 1981 · S/N BB-896 N852JPDavis Aviation Inc DBA · Brandon, MSBuilt 1979 · S/N BB-516 N858GFCal-Ore Life Flight LLC · Brookings, ORS/N BB-1858 N859GAIsr Platforms LLC · Mclean, VABuilt 1980 · S/N BT-12 N85HWHigh Notes LLC · Nashville, TNBuilt 1994 · S/N BB-1498 N85UTFly Mwm LLC · Kemah, TXBuilt 1980 · S/N BB-678 N85XPB&J Aircraft LLC · Alice, TXS/N BB1202 N860GCHiggins David L · Chevy Chase, MDBuilt 1986 · S/N BB-1245 N8611RGeneral Energy Research Group · Conroe, TXBuilt 1979 · S/N BB-482

Back to AD 89-19-04 R1