Skip to content

Registered aircraft · 81,720

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N20141Bbrrjd Inc · Wilmington, DEBuilt 1972 · S/N 17261042 N20143Loomis Aviation LLC · Gahanna, OHBuilt 1972 · S/N 17261044 N2014COharra Robert J · Buckley, WABuilt 2003 · S/N 001 N2014EWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1978 · S/N 17271118 N2014GReich Gary J Trustee · Chippewa Falls, WIBuilt 1978 · S/N MC-606 N2014LGreenwood Daniel · Golconda, ILBuilt 1966 · S/N 347 N2014PAerial Sign North · Lakewood, NJBuilt 1956 · S/N 18-4602 N2014QRegistration Pending · Glennville, GARegistration pendingBuilt 1973 · S/N 177RG0414 N2014SGaige Gerald · Gassville, ARBuilt 2006 · S/N 18281772 N20154Jones 170a LLC · Bridgman, MIBuilt 1972 · S/N 17261051 N20155Wild Wingdom LLC · Greenville, SCBuilt 1972 · S/N 17261052 N20157Kelley Aircraft LLC · Weyers Cave, VABuilt 1972 · S/N 17261053 N20158Vbp Services LLC · Wainscott, NYBuilt 1972 · S/N 17261054 N20159Western Edge Aviation LLC · Dickinson, NDBuilt 1972 · S/N 17261055 N2015QMeyer Gregory L · Lebanon, PABuilt 1973 · S/N 177RG0415 N20169R D T Aviation Inc · Williston, VTBuilt 1972 · S/N 17261062 N2016FEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13450 N2016PVladimir Ravich · Fort Montgomery, NYS/N 23-588 N20172Queen City Aero Club Inc · Chelmsford, MABuilt 1972 · S/N 17261065 N20175Jet Air Solutions Inc · Fort Myers, FLS/N 17261068 N20176Greenwood David L · Garrettsville, OHBuilt 1972 · S/N 17261069 N20177Nashville Flight School LLC · Nashville, TNBuilt 1972 · S/N 17261070 N20178Christopher Sandra A · Mabel, MNBuilt 1972 · S/N 17261071 N2017CHigher Flyer LLC · Northport, ALBuilt 1999 · S/N 18280463 N2017EPlane Fun Flying Club · Vancouver, WABuilt 1982 · S/N 18268183 N2017LLarson Lawrence Stephen · Park Rapids, MNS/N 350 N2017QGraves William D · Rock Hill, SCBuilt 1973 · S/N 177RG0417 N20181Mile High Aviation · Saint Peter, MNBuilt 1972 · S/N 17261074 N20182Gillies David K · Raymond, MEBuilt 1972 · S/N 17261075 N20183Registered aircraftBuilt 1972 · S/N 17261076 N20185Woodhams Jonathon R · South Haven, MIBuilt 1972 · S/N 17261078 N20187Dewitt Troy C · Lake Elmo, MNS/N 17261080 N20189Detroit Public Schools Community District · Detroit, MIS/N 17261081 N2018PHauer Clifford Joseph Jr · Woodstock, GABuilt 1956 · S/N 23-590 N20190Parks William T · Jasper, TNBuilt 1973 · S/N 17261082 N20191Warbington Michael L · Enid, OKBuilt 1983 · S/N 15-578 N20192Registered aircraftBuilt 1977 · S/N 17702643 N20193Gibbs Wyatt Richmond · Lodi, CAS/N 17261085 N20195Vertol Systems Company Inc · Destin, FLBuilt 1972 · S/N 17261087 N20196Bergfalk Craig Steven · Anacortes, WAS/N 17261088 N201975 Degrees North Inc · East Stroudsburg, PABuilt 1972 · S/N 17261089 N20199Worms Jeffrey J · Bonita Springs, FLBuilt 1972 · S/N 17261090 N2019ECox Garry G · Coleman, TXS/N 17271120 N2019HLrh Equipment LLC · Pendleton, ORS/N 2019 N2019LReavis William B · Yadkinville, NCBuilt 2024 · S/N 75-7610 N201ADWeyrick Zebedee · Lakeville, MNS/N 24-0359 N201AGAnjory Aviation LLC · Wausau, WIBuilt 1977 · S/N 24-0405 N201AJIndy Aero Group LLC · Pendleton, INBuilt 1977 · S/N 24-0384 N201ALRoot Home Services LLC · Leander, TXBuilt 1977 · S/N 24-0109 N201AQBoucher Bill · Faribanks, AKBuilt 1977 · S/N 24-0416

Back to AD 81-18-04 R2