Skip to content

Registered aircraft · 8,920

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:85-02-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:85-02-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:85-02-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:85-02-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:85-02-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:85-02-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.

N7966YAlbano Alan T · Elbert, COS/N 30-1064 N7967YDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 30-1065 N7968PDavison William A · Hamilton, MTBuilt 1962 · S/N 24-3205 N7968YMustang Aeronautics LLC · Chandler, AZS/N 30-1066 N796AATechnical Education Services Inc · Virginia Beach, VABuilt 1977 · S/N 27-7854036 N796NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 4496435 N7970PStevens Jon A · Byron, MNBuilt 1962 · S/N 24-3207 N7971YRegistration Pending · Collierville, TNRegistration pendingS/N 30-1070 N7974YHughes Frank H · Hackberry, LABuilt 1966 · S/N 30-1073 N7975PB&R Aircraft LLC · Wadsworth, OHBuilt 1962 · S/N 24-3212 N7977SMelkuti Attila J · Carlsbad, CAS/N 24-2547 N7977YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 30-1076 N7978PKozak Aeronautical Company · Wilmington, DEBuilt 1962 · S/N 24-3215 N7978YBurnett Philip B · Lamar, ARBuilt 1966 · S/N 30-1077 N7979PSanders Bill H · Wichita, KSBuilt 1962 · S/N 24-3216 N797NDUniversity Of North Dakota · Grand Forks, NDS/N 4496504 N797VCSantana Carlos A · San Juan, PRBuilt 1966 · S/N 27-3439 N7980PLibby Michael F · Frazier Park, CABuilt 1962 · S/N 24-3217 N7980YCherry Michael A · Winchester, ILBuilt 1966 · S/N 30-1080 N7982PSylverne Edward F · Mount Airy, MDBuilt 1962 · S/N 24-3220 N7983YMclaughlin Scott A · Defiance, IABuilt 1966 · S/N 30-1085 N7984PMiller Jason Christopher · Woodbury, NJBuilt 1962 · S/N 24-3222 N7985PScarpelli Kenneth R · Wichita, KSS/N 24-3223 N7986YRegistration Pending · Aberdeen, SDRegistration pendingBuilt 1966 · S/N 30-1089 N7988YLevel Up Aviation LLC · Dothan, ALBuilt 1966 · S/N 30-1092 N7989PAllen Rodney · Englewood, COBuilt 1962 · S/N 24-3227 N798NDYale Companies LLC · Fishers, INBuilt 2018 · S/N 4496436 N7992PEngler William O · Filion, MIBuilt 1962 · S/N 24-3231 N7993PMartz Todd B · Pleasant Hill, CABuilt 1962 · S/N 24-3232 N7994PLetourneau University · Longview, TXS/N 24-3235 N7996PFredrick Bruce T · Barrigada, GUS/N 24-3237 N7997PGilbert Aviation LLC · Mendon, VTBuilt 1962 · S/N 24-3238 N7997YN7997y Inc · Miami, FLBuilt 1966 · S/N 30-1102 N7998YAirjohn LLC · Cheyenne, WYBuilt 1966 · S/N 30-1103 N7999PAtair LLC · San Diego, CABuilt 1962 · S/N 24-3072 N799NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 4496437 N79BACampbell Allen · Marietta, PAS/N 30-1842 N79GBurke Robert · Pierre, SDBuilt 1964 · S/N 30-362 N79HLIndiana Paging Network Inc · Laporte, INS/N 27-7954046 N79JTCalifornia In Nice Inc · San Jose, CABuilt 1979 · S/N 44-7995255 N79KHPralle Jeffory K · Wasilla, AKS/N 22-6778 N79MFSkyking Aviation Services LLC · Carson City, NVBuilt 1979 · S/N 27-7954098 N79RGLouisne Gonzales · East Windsor, NJBuilt 1966 · S/N 24-4399 N7AZDevaney Aviation Inc · Palm City, FLBuilt 1968 · S/N 27-3964 N7CBExperimental Aircraft Association · Oshkosh, WIBuilt 1972 · S/N 27-4802 N7EYCharnwood Aviation Inc Trustee · Wilmington, DEBuilt 1964 · S/N 30571 N7FPBrooks David · Forney, TXBuilt 1959 · S/N 24-1160 N7HTJohns Aviation LLC · Dawson, GABuilt 1967 · S/N 30-1643 N7HURoca Roja Y Caballo Gris De Idaho LLC · Meridian, IDBuilt 1968 · S/N 30-1710 N7HWAltieri Frank J · Somerton, AZBuilt 1967 · S/N 27-3718

Back to AD 85-02-05 R1