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.

N76652Boettcher Christopher A · Benton, KSBuilt 1946 · S/N 11092 N76654Pidgeon James E · Millington, TNS/N 11094 N76657Almaguer Carlos · Mcallen, TXBuilt 1946 · S/N 11097 N7665UGazca Aaron Armando · Burgaw, NCS/N 15077791 N7665XAvz Aviation.Inc · Knoxville, TNS/N 17248165 N7666XSidaras Al · Salado, TXBuilt 1960 · S/N 17248166 N76673Delaney Patrick J · Marion, TXS/N 11113 N76677Collins Curtis R · Tennessee Colony, TXBuilt 1946 · S/N 11117 N76679Barros Arnold C · Olympia, WABuilt 1946 · S/N 11119 N7667MGier James C · Belgrade, MTBuilt 1959 · S/N 55967 N7667THembree Roy C Jr · Covington, GABuilt 1960 · S/N 47267 N7667XMatthews Thomas A · Belvidere, NJBuilt 1960 · S/N 17248167 N76680Thomas Daniel S · Willow, AKBuilt 1946 · S/N 11120 N76682Horn Norman R · Las Vegas, NVBuilt 1946 · S/N 10262 N76684Vickers Stephen F · Sandia, TXS/N 10813 N76685Sisskin Enid · Gulf Breeze, FLFirst renewal noticeS/N 10814 N76686Smyder Harold E · New Florence, PABuilt 1946 · S/N 10817 N76689Webber Cris A · Paso Robles, CABuilt 1946 · S/N 10693 N7668MNeal Daniel L · Morgan Hill, CABuilt 1959 · S/N 55968 N7668THoff Stephen R · Wilson, WYBuilt 1960 · S/N 47268 N7668UMarchbanks William W · Hillsboro, ORBuilt 1976 · S/N 15077794 N7668XEkerberg Mark J · Newton, KSBuilt 1960 · S/N 17248168 N76692Smith Gordon J · Manhattan, KSBuilt 1946 · S/N 11124 N76693Hammer Rick W · Auburn, CABuilt 1946 · S/N 11125 N76696Arrow Aircraft Leasing LLC · Mcminnville, ORBuilt 1946 · S/N 11128 N76697Brundage John R · Ann Arbor, MIBuilt 1946 · S/N 11129 N7669M95 Contracting LLC · Leander, TXBuilt 1959 · S/N 55969 N76704Riley Stephen E Trustee · Springfield, ORBuilt 1946 · S/N 11136 N76706Franklin Special School District · Franklin, TNS/N 11138 N76708Consie Robert T · Ironwood, MIS/N 11140 N7670UMatthews Christopher T · Gardnerville, NVS/N 15077796 N7670XLohrke James W · Converse, TXBuilt 1960 · S/N 17248170 N76710Soehner Harold D · Winslow, AZBuilt 1946 · S/N 11142 N76719Basinger Kenneth J · Mcdonough, GABuilt 1946 · S/N 11151 N7671MWarren Robert Scott · Harrisburg, NCBuilt 1959 · S/N 55971 N7671XBernsen Timothy Stephen · Devine, TXS/N 17248171 N76724Armi Laurence · Cardiff By The Sea, CABuilt 1946 · S/N 11156 N76728Holloway Jason · Whitewright, TXBuilt 1946 · S/N 11160 N7672XFlying Couch LLC · Orleans, MABuilt 1961 · S/N 17248172 N76731Ackerman Gary A · Plano, TXBuilt 1946 · S/N 11163 N76732Daniel Gordon W · Dillsburg, PABuilt 1946 · S/N 11164 N76735Bergen Daniel J · Vinton, IABuilt 1946 · S/N 11167 N7673TDunning Steve G · Assaria, KSBuilt 1960 · S/N 47273 N7673XDunham Randy C DBA · Lawton, OKBuilt 1960 · S/N 17248173 N76740Spencer Scott Andrew · Brownsburg, INBuilt 1946 · S/N 11172 N76742Bossola Raymond L · Suffolk, VABuilt 1946 · S/N 11174 N76743Gerken David V · Mariposa, CABuilt 1946 · S/N 11175 N76745Johnson Kenneth E · Mahtomedi, MNBuilt 1946 · S/N 11177 N76748Kuper Carl J II · Dalhart, TXBuilt 1946 · S/N 11180 N7674MMezzell James H · Cullman, ALBuilt 1959 · S/N 55974

Back to AD 94-05-05 R1