Skip to content

Registered aircraft · 54,015

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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N7050AMccollum Devin S · Flagstaff, AZS/N 29150 N7050GAircraft Management Group Inc · Honolulu, HIBuilt 1969 · S/N 17258750 N7050MCassill Aircraft Leasing · Cedar Rapids, IABuilt 1958 · S/N 55350 N7050QMindy Limited LLC · Muscatine, IABuilt 1972 · S/N 17260350 N7050SGrizzle Jason · Roscoe, TXBuilt 1967 · S/N 15067750 N70511Tanner Carlton · Coupland, TXBuilt 1968 · S/N 18259282 N70513Hummer Ernest · Bonner, MTBuilt 1968 · S/N 18259284 N70517Southern Aviation LLC · Griffin, GABuilt 1968 · S/N 18259285 N7051EKuskie Charles R · Chadron, NEBuilt 1960 · S/N 56551 N7051GWein Greggory J · Convoy, OHBuilt 1969 · S/N 17258751 N7051MForrest Trevor G · Moorpark, CABuilt 1958 · S/N 55351 N7051QBright Flight Aviation Inc · Jacksonville, FLBuilt 1972 · S/N 17260351 N7051TWeems James M · Paris, TXS/N 46651 N7051XBobka Christian · Apple Valley, MNBuilt 1961 · S/N 15059151 N70521Gray John R · Cornville, AZBuilt 1968 · S/N 18259287 N7052ESchmidt Jerry D · Spur, TXBuilt 1959 · S/N 56552 N7052GG&H Aviation · Louisville, KYBuilt 1969 · S/N 17258752 N7052QHoloman T Michael · New Smyrna Beach, FLBuilt 1972 · S/N 17260352 N7052THurst Jon M · Paw Paw, MIBuilt 1959 · S/N 46652 N70538Nordic Air LLC · Buffalo, MNS/N 18259293 N7053APearsall Timothy R · Rexford, NYBuilt 1956 · S/N 29153 N7053FAce Aeromotive Inc · Miami, FLS/N 15063653 N7053GSpare Change Enterprises LLC · Atlantic, IABuilt 1969 · S/N 17258753 N7053QCabrie Aviation Inc · Charlotte, NCBuilt 1972 · S/N 17260353 N70541Cl Finney Aviation LLC · Benton, KSBuilt 1969 · S/N 17258757 N7054AOtt Rex A · Burlington, IABuilt 1956 · S/N 29154 N7055EKleinschmidt Eric W · Livermore, CABuilt 1960 · S/N 56555 N7055QSeagraves Brad J · Rockwell, NCBuilt 1972 · S/N 17260355 N70560Blue Sky Flyers LLC · Toccoa, GAS/N 18259304 N70563Missouri-Stone Co · Cartwright, NDBuilt 1968 · S/N 18259305 N70565Langworthy Peter B · Warrensburg, MOBuilt 1968 · S/N 18259306 N70566Twin Otter International Ltd · Las Vegas, NVBuilt 1968 · S/N 18259307 N7056EBabbitt Paul A · Rohnert Park, CABuilt 1960 · S/N 56556 N7056QFleeman Joseph R · Lawrenceburg, TNBuilt 1972 · S/N 17260356 N7056THeinke John R · Paradise, CABuilt 1958 · S/N 46656 N70570Miel Del Rio Grande Inc · Monte Vista, COBuilt 1973 · S/N U20602083 N70574Blue Sky Pilots Inc DBA · Salem, ORBuilt 1968 · S/N 18259310 N7057EKoser Michael D · Asheboro, NCBuilt 1960 · S/N 56557 N7057QMindy Limited LLC · Muscatine, IAS/N 17260357 N70582Goos Aviation LLC · Meridian, IDBuilt 1968 · S/N 18259312 N7058FTechnical Education Services Inc · Virginia Beach, VAS/N 15063658 N7058GDc Aerial Photos Inc · Fredericksburg, VABuilt 1969 · S/N 17258758 N70591Fugleberg Richard H · Mayville, NDBuilt 1968 · S/N 18259315 N70594Non-Typical Airplanes LLC · Malad City, IDS/N U20602084 N70595Lung Aerial Group Inc · Tustin, CABuilt 1973 · S/N U20602085 N70597Rodriguez Hulises · Chula Vista, CABuilt 1976 · S/N 17267223 N70598Routh Lucas R · Albert Lea, MNFirst renewal noticeBuilt 1973 · S/N U20602087 N7059AWebster Mark Lawrence · Frankston, TXBuilt 1956 · S/N 29159 N7059EPennell Zackaria S · Canyon Lake, TXS/N 56559 N7059GFrank Todd E · Corsicana, TXBuilt 1969 · S/N 17258759

Back to AD 87-20-03 R2