Skip to content

Registered aircraft · 54,017

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.

N3405JRichmond Consulting LLC · Blanding, UTS/N 15066105 N3405SStutz Aaron M · Weed, CABuilt 1964 · S/N 18255805 N3405YCampbell Casey J · Sitka, AKBuilt 1967 · S/N 18051905 N34063Sherman Stephen P · Prattville, ALBuilt 1976 · S/N 177RG0957 N34064Kupka John J · Okeechobee, FLBuilt 1971 · S/N 17701622 N3406JScholle Joseph E · Mustang, OKBuilt 1967 · S/N 15066106 N34072Baden Aviation LLC · North Royalton, OHBuilt 1976 · S/N 177RG0960 N34077Registration Pending · Santa Monica, CARegistration pendingBuilt 1976 · S/N 177RG0961 N3407DThaxton Todd J · Williamson, GAS/N 26950 N3407FHoltzinger Tyler · Muscle Shoals, ALBuilt 1966 · S/N 18257407 N3407LRoadarmel Brandon · Bozeman, MTBuilt 1966 · S/N U206-0707 N3407SWeaver Jason Andrew · Germantown, TNBuilt 1964 · S/N 18255807 N3407UNote Clayton Rex · Eagle Point, ORBuilt 1963 · S/N 18254807 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 N3408RFronapfel Hannah A · Palmer, AKBuilt 1967 · S/N 18258708 N3408TSpectron Aviation Inc · West Boylston, MAS/N 17700708 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 N3409JMountain Home Oasis LLC · Albuquerque, NMBuilt 1967 · S/N 15066109 N3409RAnderson Curtiss B · Heber Springs, ARBuilt 1968 · S/N 18258709 N3409YThies Trevor H · Seattle, WABuilt 1967 · S/N 18051909 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 N3410CGreer Jack D · Gillette, WYS/N 26453 N3410DGuillory Dan Jr · Eunice, LABuilt 1955 · S/N 26953 N3410FMacy Richard H · Culver, ORBuilt 1966 · S/N 18257410 N3410JNewsom Rickey D · Springfield, ARS/N 15066110 N3410REpperly Scott C · Montague, CABuilt 1967 · S/N 18258710 N3410SDurtschi Jay W · Franklin, IDBuilt 1964 · S/N 18255810 N3410TPeterson Barry · Sausalito, CABuilt 1967 · S/N 17700710 N3410UWegman Aviation LLC · Kenmore, NYBuilt 1963 · S/N 18254810 N3411DBox 4-S Ranch Inc · Pullman, WABuilt 1955 · S/N 26954 N3411ROgp LLC · Wilmington, DEBuilt 1967 · S/N 18258711 N3411SHorseshoe 182 LLC · Dickinson, NDBuilt 1964 · S/N 18255811 N3411TSouthern Aero LLC · Theodore, ALBuilt 1967 · S/N 17700711 N3411USutton Aircraft Salvage LLC · Palmer, AKBuilt 1963 · S/N 18254811 N3411YFinnelly Barry J · Snohomish, WAS/N 18051911 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 N3412DBerens Brian T · Homer, AKBuilt 1955 · S/N 26955 N3412FClaretta Inc · Wilmington, DEBuilt 1966 · S/N 18257412

Back to AD 87-20-03 R2