Skip to content

Registered aircraft · 26,230

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.

N11527Red Oak Commuter LLC · Red Oak, IABuilt 1973 · S/N 15075489 N11528Streeter Derek · Guilford, CTBuilt 1973 · S/N 15075490 N11529Registration Pending · Mattituck, NYRegistration pendingBuilt 1973 · S/N 15075491 N1152HWeiler Coen A · Ashville, OHBuilt 1948 · S/N 15AC-165 N11531Ireland Lois Trustee · Herndon, VAS/N 15075493 N11533Neal Robert J · Martinsville, INBuilt 1973 · S/N 15075495 N11534Litzau Melissa · Lake Lillian, MNS/N 15075496 N11538Fallon James R · Chestnut Hill, MABuilt 1973 · S/N 15075500 N1153DCarbonaro Joseph J Jr · Lexington Park, MDBuilt 1951 · S/N 15716 N11540Eddleston Ryan · Winter Haven, FLBuilt 1973 · S/N 15075502 N11546De Souza Alex Henrique · Newark, NJBuilt 1973 · S/N 15075508 N1154HLechner Burdette J · Kodiak, AKBuilt 1948 · S/N 15AC-167 N11552Dunn Ashley L · Mc Alpin, FLBuilt 1973 · S/N 15075514 N11554Groux Robert E Jr · Spring, TXBuilt 1973 · S/N 15075516 N11558Cwi Air Motive Inc · Grant Park, ILBuilt 1973 · S/N 15075519 N1155FDejesus Rodolfo B · Murfreesboro, TNBuilt 1966 · S/N 17254750 N11561Marsh John E · Washington, DCS/N 15075522 N11563Hunnewell Aviation Services Inc · La Crescent, MNBuilt 1973 · S/N 15075524 N11569Cornejo Jose Valente · Scottsdale, AZS/N 15075529 N11570Wilson Steven J · Elkton, KYBuilt 1973 · S/N 15075530 N11571Sale Reported · Spokane, WASale reportedBuilt 1973 · S/N 15075531 N11573Airfleet Solutions LLC · Newark, DEBuilt 1973 · S/N 15075533 N11575Pyle Howard H · Cornelius, ORBuilt 1950 · S/N 19540 N11577Tre Aviation Corp · Wilmington, DEBuilt 1973 · S/N 15075534 N1157CCavill Wayne E · Ryegate, MTBuilt 1953 · S/N 18-2458 N1157FKiss George C · Bangor, PAS/N 17254752 N1157YMoles Dale A · Mooresburg, TNBuilt 1962 · S/N 15059557 N11587Stark Avionics LLC · Panama City, FLS/N 15075543 N11589Harbert Gary J II · Newville, ALFirst renewal noticeBuilt 1973 · S/N 15075545 N1158FAmerican Pride Aviation LLC · Newport Beach, CABuilt 1966 · S/N 17254753 N1158YAas LLC · Ovid, MIBuilt 1962 · S/N 15059558 N11590Ramaswamy Gautam · Clearwater, FLS/N 15075546 N11592Vu Ai Thi · Aiea, HIBuilt 1973 · S/N 15075548 N11594Reynolds Eugene II · Gastonia, NCBuilt 1973 · S/N 15075550 N1159FRodimel Troy R · Greenwood, INS/N 17254754 N115CGGosch Clint L · Cedar Rapids, IABuilt 2018 · S/N 75-8457 N115DDahl Samuel L · Moses Lake, WABuilt 2014 · S/N 6-5530 N115ELutz Roald F · Sandia Park, NMBuilt 1983 · S/N 022 N115JFFields Joseph H · Placerville, CAS/N 13498 N115MBChalet Suzanne Aviation Inc · Lake Wales, FLS/N 17248936 N115RFPeabody Riley A · Minnetonka, MNBuilt 1961 · S/N 17556810 N11605Airelectric Inc · Tulsa, OKBuilt 1973 · S/N 15075561 N11607Cutrubus James G DBA · Ogden, UTBuilt 1973 · S/N 15075563 N1160BMees Martin B · Eagle River, AKBuilt 1947 · S/N 5787 N1160FOcala Aviation Services Inc · Ocala, FLS/N 17254755 N11610Jensen Greg D · Omaha, NES/N 15075565 N11616Registration Pending · San Bernardino, CARegistration pendingBuilt 1974 · S/N 15075570 N11619Lewis Billy D · Cleveland, GABuilt 1974 · S/N 15075573 N1161FBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 17254756 N11621Hopkins Josh · Corpus Christi, TXS/N 15075575

Back to AD 94-05-05 R1