Skip to content

Registered aircraft · 40,473

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-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N6757UScherger Mark A · Herndon, VABuilt 1963 · S/N 2479 N6758HGorge Winds Aviation Inc · Fairview, ORBuilt 1975 · S/N 17265570 N6758JBroach William S · Forest Hill, MDBuilt 1968 · S/N 28-24828 N6758NZwerko Kevin C · South Plainfield, NJBuilt 1968 · S/N 680072 N6758PRoss David T · El Dorado Hills, CABuilt 1960 · S/N 24-1887 N6758UN6758u LLC · Linden, MIBuilt 1963 · S/N 2480 N6759BDean Richard L · Ridgeland, SCBuilt 1956 · S/N 22-4094 N6759UHodgson Michael D · Saint Francis, WIBuilt 1963 · S/N 2481 N6759WMakeev Alexandre · Concord, CABuilt 1965 · S/N 28-20884 N675JBRegistered aircraftBuilt 2004 · S/N 22950 N675QFisher Global LLC · Conway, ARBuilt 1959 · S/N TD-246 N675RFGoodson Danny R · Bristol, VABuilt 2021 · S/N 21845 N6760BAnderson Michael N · Anchorage, AKBuilt 1954 · S/N 18-5035 N6760WBitter Loren Mark · Maricopa, AZBuilt 1965 · S/N 28-20885 N6761UJaeger Howard E · Claremore, OKBuilt 1963 · S/N 2483 N6761WGirdley James Kevin · Taylorsville, KYBuilt 1965 · S/N 28-20886 N6762BCarver Clarence K Trustee · Lutz, FLBuilt 1956 · S/N 18-5037 N6762NTaylor Norman A · Fayette, ALBuilt 1968 · S/N 680076 N6763JMiddlestetter Matthew G · Green Cove Springs, FLBuilt 1968 · S/N 28-24487 N6763NRegistration Pending · Minden, NVRegistration pending, pending cancellationBuilt 1968 · S/N 680077 N6763PHeublein Eric C · Molalla, ORBuilt 1960 · S/N 24-1893 N6764BMccollum Glen R Jr · Nikiski, AKBuilt 1956 · S/N 18-5039 N6764JZalik Michael A · San Francisco, CABuilt 1968 · S/N 28-24488 N6765NBogdan Joseph H · Soper, OKBuilt 1968 · S/N 680088 N6765WKakoczki Robert J · White Cloud, MIBuilt 1965 · S/N 28-20891 N6766BRutland Norman L Jr · Birmingham, ALBuilt 1956 · S/N 18-5041 N6767BHolseberg Aviation LLC · Ridgeville, SCBuilt 1956 · S/N 18-5042 N6767CSilverstein Devyn · Austin, TXBuilt 1967 · S/N 670130 N6767JLarson Wayne K · Amboy, CABuilt 1968 · S/N 28-24491 N6767NEichhorn Tyler L · Paonia, COBuilt 1968 · S/N 680089 N6768BKimmel Frank Stewart III · Greenwood, MSBuilt 1957 · S/N 18-5046 N6768FFallis Robert P · Keller, TXBuilt 1972 · S/N AA5-0182 N6768JSuncoast Flight Training LLC · Sarasota, FLBuilt 1968 · S/N 28-24492 N6768NPorthouse Chris · Bellingham, MABuilt 1968 · S/N 680080 N6768PKeenan John E · Saratoga, CABuilt 1960 · S/N 24-1899 N6768UBranson Randel L · Eclectic, ALBuilt 1963 · S/N 2490 N6768WCimeira Aviation LLC · Birmingham, ALBuilt 1965 · S/N 28-20895 N6769JHanson Tobin S · Westlake, ORBuilt 1968 · S/N 28-24493 N6769NCausey Kevin L · Bainbridge, GABuilt 1968 · S/N 680081 N6769PKroll Richard L · Montague, MIBuilt 1960 · S/N 24-1900 N6769UWard Leonard · Preston, IDBuilt 1963 · S/N 2491 N676AKDillard Clayton B · Talkeetna, AKBuilt 2022 · S/N CD001 N676CHTake Off Aviation Services LLC · Rockledge, FLBuilt 1976 · S/N 17266905 N676FLEdwards William J · Big Rapids, MIBuilt 1971 · S/N 28-7125605 N676NLoftus Timothy P · Mclean, VABuilt 1968 · S/N 680032 N676QKeil Urban G · The Villages, FLBuilt 2002 · S/N 4213 N676WLeymaster Michael J · Westerville, OHBuilt 1977 · S/N AA5B0676 N6770NGrant William S · Azle, TXBuilt 1968 · S/N 680090 N6771FDecruz Enterprises LLC · Hattiesburg, MSBuilt 1976 · S/N 28-7715178 N6771VBrice Michael · Dickinson, NDBuilt 1970 · S/N 700078

Back to AD 80-04-03 R2