Skip to content

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N7380RLewis University · Romeoville, ILBuilt 1978 · S/N R18200650 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 N7382NTerracon Pipelines Inc · Healdsburg, CABuilt 1974 · S/N 18263165 N7382QOsterman Michael A · Maplewood, MNBuilt 1972 · S/N 18261022 N7383XMcdonald Michael R · Sunnyvale, CABuilt 1977 · S/N R18200094 N7384CFesco Holdings Inc · Alice, TXBuilt 1980 · S/N 21063951 N7384SPluemer Steven W · Los Lunas, NMBuilt 1976 · S/N 18265175 N7384UGrant Aviation Inc · Anchorage, AKBuilt 1978 · S/N 20700431 N7385EGibson Gregory T · Ivel, KYS/N 57085 N7385SZia Air LLC · Hagerman, NMS/N 18265176 N7386CAgro Engineering Inc · Alamosa, COBuilt 1977 · S/N U20603916 N7386ESwensen Nathan E · Winnemucca, NVS/N 57086 N7386NVincent Elridge J · Abbeville, LABuilt 1974 · S/N 18263169 N7387NMorgan Sheilds Aircraft LLC · Katy, TXBuilt 1974 · S/N 18263170 N7388NFerguson James S · Adrian, MOBuilt 1974 · S/N 18263171 N7388QJohnson Timothy R · Aguila, AZBuilt 1972 · S/N 18261028 N7389EWeber James D · Benton City, WABuilt 1960 · S/N 57089 N7389NKns Properties · Perry, IAS/N 21063226 N7389TWeaver James C · Dunwoody, GABuilt 1977 · S/N R18200035 N7389UYr-Aircraft Leasing LLC · Bethel, AKBuilt 1978 · S/N 20700432 N738AEAvco Patrol LLC · Lyndon, KSS/N R18200903 N738AXBlevins Donald Paul · Forest, VABuilt 1979 · S/N R18200905 N738CKPhillips E Rolland · Concord, NCBuilt 1979 · S/N R18200911 N738CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281761 N738EELipira Robert S · Melbourne, FLBuilt 1979 · S/N R18200916 N738EQElliott Darren · Vega, TXS/N R18200917 N738FRamp 106 LLC · Lynn Haven, FLBuilt 1979 · S/N 18266881 N738LPPython Financial LLC · Kalispell, MTBuilt 1979 · S/N R18200938 N738PGBas Part Sales LLC · Greeley, COBuilt 1979 · S/N R18200949 N738PRS D Sky Tales Inc · Chuckey, TNBuilt 1979 · S/N R18200951 N738QKSik Kelly · Murrieta, CABuilt 1979 · S/N R18200953 N738TFFly Vector LLC · Spring Hill, FLBuilt 1979 · S/N R18200958 N738UUCiuccio Louis V · Old Forge, PABuilt 1979 · S/N R18200963 N738WKMallette Christopher Lee · Saint Rose, LABuilt 1979 · S/N R18200969 N738ZBDyberg Mike · Mount Vernon, WABuilt 1979 · S/N R18200976 N7390QChesmore Daniel R · Ten Mile, TNBuilt 1972 · S/N 18261030 N7392USpernak Airways Inc · Anchorage, AKFirst renewal noticeBuilt 1978 · S/N 20700435 N7393EN7393 LLC · Saint Augustine, FLBuilt 1960 · S/N 57093 N7394NPritchett Randal M · Kingfisher, OKBuilt 1974 · S/N 18263177 N7394SFourcher Fredric · Corona Del Mar, CABuilt 1976 · S/N 18265184 N7395ERegistered aircraftBuilt 1959 · S/N 57095 N7395SJamison Russell D · Quinter, KSBuilt 1976 · S/N 18265185 N7395XBrl Air LLC · Onsted, MIBuilt 1977 · S/N R18200097 N7396NAd Astra Aviation Services LLC · Saline, MIBuilt 1974 · S/N 18263179 N7396QBoling Justin · Eureka, MOBuilt 1972 · S/N 18261036 N7396SThomas James H Jr · Boulder, COBuilt 1976 · S/N 18265186 N7396UAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1978 · S/N 20700438 N7397QCabral Jesse J · Whitethorn, CABuilt 1972 · S/N 18261037

Back to AD 84-10-01 R1