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.

N2035LChris Fuher Flight Instruction LLC DBA · Townsend, MTBuilt 1967 · S/N 368 N2035QDonn E Mount Realty Inc · Titusville, FLBuilt 1973 · S/N 177RG0435 N2035ULihs Ashley · Yankton, SDBuilt 1974 · S/N 28-7415467 N20360Jaynair Corp DBA · Middlebury, CTFirst renewal noticeBuilt 1972 · S/N 17261222 N20363Soldan Rafael · Wichita, KSS/N 17261225 N20364Piper Capital Growth Fund LLC · Scottsdale, AZBuilt 1972 · S/N 17261226 N20365Atlas Aero Training LLC · Casper, WYBuilt 1972 · S/N 17261227 N20366Depouli Raymond M · Enumclaw, WABuilt 1972 · S/N 17261228 N20368Beaver Flying Club Inc · Xenia, OHS/N 17261230 N2036GYoung Robert E · Apple Valley, CAS/N 0214 N2036MR&B Helicopters Inc · Calhoun, GABuilt 2000 · S/N 0114 N2036QEtling Carl G · Edgar, NEBuilt 1973 · S/N 177RG0436 N2036TLane James · Raleigh, NCBuilt 1983 · S/N TC1 N20375May Matthew J · Weatherford, TXBuilt 1977 · S/N 17702664 N20376Kelley Aircraft LLC · Weyers Cave, VABuilt 1972 · S/N 17261237 N20377Moore James E · Arroyo Grande, CABuilt 1972 · S/N 17261238 N2037PKuklo Robert M · Livermore, CABuilt 1956 · S/N 23-614 N20381Dsr-Cherokee 180 LLC · Dallas, TXBuilt 1972 · S/N 17261241 N20382Bass Philip D · Oviedo, FLS/N 17261242 N20384Rutherford Jeffrey L · Montgomery, ALBuilt 1972 · S/N 17261244 N20387Bybee Mark J · De Soto, ILBuilt 1972 · S/N 17261247 N20389Kcn Aero Club Inc · Overland Park, KSBuilt 1972 · S/N 17261249 N2038EStevens Michael J Jr · Humble, TXBuilt 1978 · S/N 17271127 N20390Mitiguy Aviation LLC · Stow, MABuilt 1972 · S/N 17261250 N20392Registration Pending · Miami, FLRegistration pending, pending cancellationBuilt 1972 · S/N 17261252 N20393Nextgen Flying LLC · Pigeon Forge, TNBuilt 1972 · S/N 17261253 N20398Laron W Hall · Hurricane, UTBuilt 1972 · S/N 17261258 N20399Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1972 · S/N 17261259 N2039PPearlman Aircraft Co · Orlando, FLBuilt 1956 · S/N 23-622 N203BCHamilton Fred C · Fairbanks, AKBuilt 2003 · S/N 6874 N203BWAlexander Katherine · Fishers, INBuilt 1976 · S/N 28R-7635113 N203CCMonarch Air LLC · Dewitt, MIBuilt 1979 · S/N 28-7911110 N203CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12501 N203DAerotres LLC · Lakeville, MNBuilt 2020 · S/N 2881425 N203DMCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1966 · S/N 27-3461 N203DSSouth Mountain Aero LLC · Myerstown, PABuilt 2002 · S/N 40.203 N203EAEtheredge Mark · Pell City, ALBuilt 2023 · S/N 28020118 N203FSpace Coast Aircraft Co · Merritt Island, FLBuilt 1984 · S/N 288416083 N203GTUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 1979 · S/N 17272403 N203JCJanzen Brian · Fort Worth, TXBuilt 2003 · S/N 003JC N203JJMidwest Aircraft Sales LLC · Lincoln, NEBuilt 2006 · S/N 40290 N203KSMichael Lichtman Inc · Oceanside, CAFirst renewal noticeBuilt 2001 · S/N 172S8856 N203LELeading Edge Flight Academy LLC · Bend, ORS/N 11203 N203LFAction Aviation LLC · Idaho Falls, IDS/N 20-1018 N203MABuckau Michael S · Costa Mesa, CABuilt 1970 · S/N 28-26738 N203MDSinsaja Holdings LLC · Sheridan, WYBuilt 1976 · S/N 28-7625251 N203RVQualitair LLC Trustee · MichelstadtS/N 597 N203SWellness Flight LLC · Bradenton, FLBuilt 1956 · S/N 23-412 N203SCWesley Robert J · Chuckey, TNBuilt 1966 · S/N 30-1118 N203TProfota Don L · Bozeman, MTBuilt 1953 · S/N 18-2317

Back to AD 81-18-04 R2