Skip to content

Registered aircraft · 54,015

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N737YXTichenor Warren White II · Auburn, WABuilt 1979 · S/N R18200897 N737YZWininger Spencer C · Wichita, KSBuilt 1977 · S/N 17269790 N737ZACounty Of Santa Cruz · Santa Cruz, CABuilt 1977 · S/N 17269791 N737ZCMoody Air Ventures LLC · Nolanville, TXBuilt 1977 · S/N 17269793 N737ZDHp Air Inc · Cape Coral, FLBuilt 1977 · S/N 17269794 N737ZGDuck Air LLC · Mooresville, NCBuilt 1977 · S/N 17269797 N737ZJLazy Eights Holdings LLC · Greenwood, INBuilt 1977 · S/N 17269799 N737ZKAk Fly Inc · Kasilof, AKBuilt 1977 · S/N 17269800 N737ZNEquinoxx Flight Systems LLC · Lawrenceville, GABuilt 1977 · S/N 17269803 N737ZPJahawk Leasing LLC · Sugar Grove, ILBuilt 1977 · S/N 17269804 N737ZRTennessee Seaplane Company LLC · Knoxville, TNBuilt 1977 · S/N 17269806 N737ZTEdwards Ronald R · Clinton, ARBuilt 1977 · S/N 17269808 N737ZVJax Aero LLC · Jacksonville, FLBuilt 1977 · S/N 17269810 N737ZWS & S Aviation Co · Ball Ground, GAS/N 17269811 N737ZZRandick George A · Birch Run, MIBuilt 1979 · S/N R18200901 N73800Soul Aviation LLC · Newport Beach, CABuilt 1976 · S/N 17267690 N73808Delta Aviation Inc · Monticello, MNBuilt 1976 · S/N 17267691 N7380GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259080 N7380HCoggins Craig C · Nome, AKS/N 18503384 N7380KKxp Ventures LLC · Piedmont, SCFirst renewal noticeBuilt 1976 · S/N R1722067 N7380LAsiatico Ruperto M · Virginia Beach, VABuilt 1978 · S/N A1520799 N7380NWolverton Engineering Inc · Collins, MSBuilt 1974 · S/N 18263163 N7380RLewis University · Romeoville, ILBuilt 1978 · S/N R18200650 N7380TAndersen William A · Flagstaff, AZBuilt 1959 · S/N 46980 N73813Smoot Russell L · Louisville, KYBuilt 1976 · S/N 17267693 N73816Nedved Aviation LLC · Mitchell, SDBuilt 1976 · S/N 17267696 N73819Botter Marlene S Trustee · Kent, WABuilt 1976 · S/N 17267699 N7381EDill Terry L · Delphi, INBuilt 1960 · S/N 57081 N7381NHorizon Enterprises LLC · Kalispell, MTS/N 18263164 N7381QBooth Sean A · Auburn, CABuilt 1972 · S/N 18261021 N7381VEvarts Roy K · Northborough, MABuilt 1977 · S/N R1722306 N7382AWretschko Brian W · Phoenix, AZBuilt 1956 · S/N 29482 N7382MPansza Michaelangelo · Poteet, TXBuilt 1958 · S/N 55682 N7382NTerracon Pipelines Inc · Healdsburg, CABuilt 1974 · S/N 18263165 N7382QOsterman Michael A · Maplewood, MNBuilt 1972 · S/N 18261022 N73830Asbury Paul G · Charleston, TNBuilt 1976 · S/N 17267706 N73837Bloomex Aviation LLC · Montvale, NJS/N 17267711 N7383LChicken Hawk Aviation LLC · Strasburg, COS/N 17273259 N7383MRegistered aircraftS/N 55683 N7383TLeach Jeff · Terlingua, TXS/N 46983 N7383XMcdonald Michael R · Sunnyvale, CABuilt 1977 · S/N R18200094 N73846Bernstein Matthew D · North Charleston, SCBuilt 1976 · S/N 17267717 N73848Dorson Daniel J · Eden Prairie, MNBuilt 1976 · S/N 17267719 N7384CFesco Holdings Inc · Alice, TXBuilt 1980 · S/N 21063951 N7384EFierman Jo Angela · Madison, GABuilt 1978 · S/N 17272100 N7384SPluemer Steven W · Los Lunas, NMBuilt 1976 · S/N 18265175 N7384TMclaughlin James L · Centerburg, OHS/N 46984 N7384UGrant Aviation Inc · Anchorage, AKBuilt 1978 · S/N 20700431 N7384XGlenn Larry W · Bunn, NCS/N 15059484 N73852Carrion Jesus · Staten Island, NYBuilt 1976 · S/N 17267721

Back to AD 87-20-03 R2