Skip to content

Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N3405FGo Up High LLC · Grafton, WIBuilt 1967 · S/N 17700602 N3405XMurray Lacounte O · Leander, TXBuilt 1966 · S/N 3391 N34063Sherman Stephen P · Prattville, ALBuilt 1976 · S/N 177RG0957 N34064Kupka John J · Okeechobee, FLBuilt 1971 · S/N 17701622 N3406XThuerauf John E · Plum City, WIBuilt 1966 · S/N 3392 N34072Baden Aviation LLC · North Royalton, OHBuilt 1976 · S/N 177RG0960 N34077Registration Pending · Santa Monica, CARegistration pendingBuilt 1976 · S/N 177RG0961 N3407XAerodrome Aviation LLC · Brighton, COBuilt 1966 · S/N 1110 N34080Rodell Justin A · Saint Paul, MNBuilt 1976 · S/N 177RG0963 N34081Danko James A · Norton, OHS/N 177RG0964 N34084Cardinal Aviation LLC · Eureka, MOBuilt 1976 · S/N 177RG0965 N3408TSpectron Aviation Inc · West Boylston, MAS/N 17700708 N3408XHeid Jason A · Crystal, MNBuilt 1966 · S/N 1111 N34096Mirafuentes Akoni Jr · Surprise, AZBuilt 1976 · S/N 177RG0970 N34097Brennan Benjamin M · Pensacola, FLBuilt 1971 · S/N 17701638 N34099Nehrbass Daniel · Santa Ana, CABuilt 1971 · S/N 17701639 N3409NSchaffhauser Daniel · Garland, TXBuilt 1967 · S/N 680042 N340ACMajor Travis S · Phoenix, AZBuilt 2003 · S/N 1340-2003 N340BMInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 24-0421 N340SXHeavy Metal Air LLC · Farmingdale, NYBuilt 1981 · S/N 15285141 N34101Aldrich Andrew J · Soulsbyville, CABuilt 1971 · S/N 17701641 N34102Jaquez Marlene D · Baton Rouge, LABuilt 1971 · S/N 17701642 N34104Mcgowan Glenn R · Poplar Grove, ILBuilt 1971 · S/N 17701644 N34106Bellmann Carl W · Bryan, OHBuilt 1971 · S/N 17701646 N34108Pierce Andrew · Littleton, NCBuilt 1971 · S/N 17701647 N3410NPedersen Bruce J · Sandpoint, IDS/N 680043 N3410TPeterson Barry · Sausalito, CABuilt 1967 · S/N 17700710 N3411TSouthern Aero LLC · Theodore, ALBuilt 1967 · S/N 17700711 N3411XLo Lo Aviation Inc · Wilmington, DEBuilt 1966 · S/N 3394 N34121Downey Colin T · Jupiter, FLBuilt 1971 · S/N 17701650 N34122Cardinal Flying Club LLC · Saint Helens, ORBuilt 1971 · S/N 17701651 N34125Quinones Horacio Adan Gil · Palmdale, CABuilt 1971 · S/N 17701652 N34129Shook Mitchell M · Vidalia, GABuilt 1971 · S/N 17701653 N3412TC177knotclub LLC · Springfield, ILBuilt 1967 · S/N 17700712 N34133Geneva Lakes Flying LLC · Bristol, WIBuilt 1971 · S/N 17701654 N34138Wheat Michael D · Wichita Falls, TXBuilt 1971 · S/N 17701656 N34139Registered aircraftBuilt 1971 · S/N 17701657 N34140Beacham Clinton S · Pleasanton, CABuilt 1976 · S/N 177RG0972 N34146Aegis Aero LLC · Vancleave, MSBuilt 1971 · S/N 17701664 N34147Ferguson Claudia K Trustee · Orange, CABuilt 1971 · S/N 17701665 N34148Rupp Gregory J · Deltona, FLS/N 17701666 N34149Juniper Ventures LLC · Missoula, MTBuilt 1971 · S/N 17701667 N3414TKkk Services Inc · Saint Charles, MOBuilt 1967 · S/N 17700714 N3414XMoore Jason E E · Tomball, TXBuilt 1966 · S/N 1115 N34150Mcalindon Timothy E · Arlington, MABuilt 1971 · S/N 17701668 N34153Furness Donald Craig · Pottsboro, TXBuilt 1972 · S/N 17701671 N34154Sepko Joseph M III · Carrollton, TXBuilt 1971 · S/N 17701672 N34156King Gregory J · Friday Harbor, WABuilt 1971 · S/N 17701674 N3415XHackford Dalton Decory · Vernal, UTS/N 3395 N34161Wood Robert A · Sarasota, FLBuilt 1976 · S/N 177RG0976

Back to AD 80-25-07 R1