Skip to content

Registered aircraft · 40,396

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

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 N6772JMaljanion Mark D · Upton, MABuilt 1968 · S/N 28-24497

Back to AD 79-10-03 R2