Skip to content

Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N5639RKeith L S · Forestburg, TXBuilt 1965 · S/N 17253262 N563FSPatterson Marshall S · Tuscumbia, ALBuilt 1967 · S/N 15066188 N563GMarsh Matthew · Cleveland, ALBuilt 1968 · S/N 15068275 N563GSGilderhus Edwin T · Oberon, NDS/N 15071468 N563RSRaven Bryan F · Lakeland, FLS/N 17255866 N5640ASanders David L · Powell, WYBuilt 1956 · S/N 28240 N5640FMcneill William F · Raeford, NCBuilt 1967 · S/N A-240 N5640RUnruh Jerel W · Versailles, MOBuilt 1965 · S/N 17253264 N5641DKimble Milt · Houston, TXS/N 221 N5641FBogue Bruce E · Washington, MOBuilt 1967 · S/N A-241 N5641REaton Samuel D · Clinton, PABuilt 1965 · S/N 17253265 N5641TMarcy Dara Owen · Tacoma, WABuilt 1964 · S/N 17251541 N5642AMoore Alton O III · Lago Vista, TXS/N 28242 N5642FTiger Flight Foundation Inc · Rome, GABuilt 1967 · S/N A-242 N5642RMatheny Roger P · Humble, TXBuilt 1965 · S/N 17253266 N5643ARosansky Jeff S · Weldon Spring, MOBuilt 1956 · S/N 28243 N5643FWoodhaven Air LLC · Blue Springs, MOBuilt 1967 · S/N A-243 N5644CRegistered aircraftBuilt 1950 · S/N 15598 N5644RShaffer Mark J · Porterfield, WIBuilt 1965 · S/N 17253269 N5644TScootair LLC · Alburgh, VTBuilt 1964 · S/N 17251544 N5645AAll Seasons Catering Inc · Shelter Isl, NYBuilt 1956 · S/N 28245 N5645EHagen Edward E · New Auburn, WIBuilt 1959 · S/N 17145 N5645RGecha Brian S · Brandon, VTBuilt 1965 · S/N 17253270 N5645TJ & J Aviation Inc · Martinsville, VABuilt 1964 · S/N 17251545 N5646AHeffron Jacob L · Little Falls, MNS/N 28246 N5646CBivens Jason D · Duncan, OKBuilt 1950 · S/N 15600 N5646RAumack Bryant D · Melbourne, FLBuilt 1965 · S/N 17253272 N5647TJohnson Jeffri K · Brighton, COBuilt 1964 · S/N 17251547 N5648AMartin Rand E · Lake Stevens, WAS/N 28248 N5648EHanna Charles M · Luthersville, GABuilt 1959 · S/N 17148 N5648RKurtz Richard G · Ithaca, NYS/N 17253275 N5648TYankton Area Aviators Inc · Crofton, NEBuilt 1964 · S/N 17251548 N5649AMinor Charles G · Medford, ORS/N 28249 N5649CRon Alexander Youth Aviation Program · Williamson, GABuilt 1950 · S/N 15603 N564EDTilse William A · Kirkland, WABuilt 1956 · S/N 28362 N564QLSimcic Kathryn C · Grain Valley, MOBuilt 1969 · S/N 15070570 N564SKOrback Michael J · Loveland, COS/N S70203-009 N5650CMorris Kenneth E · Poplar Grove, ILBuilt 1950 · S/N 15604 N5650FMcdonald Ryan · Sugarland, TXBuilt 1967 · S/N B-250 N5650TWander Harry J · Nevada City, CABuilt 1964 · S/N 17251550 N5651RChickasha Wings Inc · Chickasha, OKBuilt 1965 · S/N 17253279 N5651TRegistered aircraftS/N 17251551 N5652APatriot Aviation · Loomis, CABuilt 1956 · S/N 28252 N5652FHayden Robert P · West Fargo, NDBuilt 1966 · S/N A-152 N5653FCrowe James E · Sylvester, GABuilt 1966 · S/N A-153 N5653GCavanaugh Joseph Rex · Alvin, TXBuilt 1969 · S/N 15071153 N5654CGelardo Matthew L · Cardiff By The Sea, CAS/N 15610 N5654GNorman Charles E · Zanesville, OHBuilt 1969 · S/N 15071154 N5654RSudbrink Charles D · Willet, NYS/N 17253283 N5654THayes Travis · Harrisonville, MOS/N 17251554

Back to AD 94-05-05 R1