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.

N6237UCardoza Roger A · Fairbanks, AKBuilt 1962 · S/N 2076 N6238WBurns Benjamin · Rockport, TXBuilt 1964 · S/N 28-20280 N6239DAerial Precision LLC · Entiat, WAS/N 17272657 N6239FEckert Ted · Cedar Creek, TXBuilt 1979 · S/N 17273172 N6239ZQuickflight LLC · Mazomanie, WIBuilt 1960 · S/N 25-290 N623FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7816131 N623JEHanni Walter G · Anchorage, AKBuilt 1965 · S/N 18-8272 N623LDDurban Lars · Snohomish, WABuilt 2020 · S/N 92232 N623MPKimball Duane A · Wasilla, AKBuilt 1964 · S/N 188090 N623RCWatt Nathan A B · Walnut Creek, CABuilt 2001 · S/N 25532 N623SCTiger Pilots Inc · Iowa City, IABuilt 1979 · S/N AA5B1199 N623WJAir Mods And Repair · Robbinsville, NJBuilt 1974 · S/N 28R-7435109 N62405Flight School Of Gwinnett Inc · Lawrenceville, GABuilt 1981 · S/N 17275263 N62407Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17275264 N6240ULewis Ricky Ll · Cisco, TXBuilt 1962 · S/N 2079 N6241UPalmer Charles L · Huntington Beach, CABuilt 1962 · S/N 2080 N6241WKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1964 · S/N 28-20284 N62425Dodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 17275267 N62427Rabaut Charles P · Oceanside, CABuilt 1997 · S/N 3786 N62429Fowler Cary D · Hayti, MOBuilt 1981 · S/N 17275268 N6242CFlight School 101 LLC · Winter Haven, FLBuilt 1978 · S/N 28-7816399 N6242JEast Coast Autoline LLC · Whitehall, PAS/N 28-7625234 N6242WPettie Randall D · Baltimore, MDBuilt 1964 · S/N 28-20239 N62444Ditmer Jack L Jr · Troy, OHBuilt 1981 · S/N 17275271 N62447Tri-State Flg Club Inc · Huntington, WVBuilt 1981 · S/N 17275272 N6244JReid Michael · Morgan Hill, CABuilt 1976 · S/N 28-7615343 N6244UHawthorn Seth A · New Vienna, OHBuilt 1962 · S/N 2083 N6244WTaylors Turf Paradise LLC · Whitewater, WIBuilt 1964 · S/N 28-20288 N62457Pisarello William J · Sebring, FLBuilt 1981 · S/N 17275275 N6245DJeffery & Weiss Holdings LLC · Long Beach, CABuilt 1979 · S/N 17272661 N6245PBishop Warren · Iowa City, IABuilt 1959 · S/N 24-1351 N6245UMcgee Joel M · Woodford, VAS/N 2084 N62475Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275279 N6247JInternational Air Services Inc Trustee · Carson City, NVS/N 28-7690380 N6247USchaefer John A · Liberty Hill, TXBuilt 1962 · S/N 2086 N62486486 Aviation LLC · Worthington, OHBuilt 1981 · S/N 17275280 N62488Leaf Air LLC · Queensbury, NYBuilt 1981 · S/N 17275282 N6248CFort Leavenworth Flying Club · Fort Leavenworth, KSS/N 28-7816629 N6248DEscobar Frank · Tampa, FLBuilt 1979 · S/N 17272663 N62491Registration Pending · Strawn, TXRegistration pendingS/N 18-7709037 N6249VN6249v LLC · Park Ridge, ILBuilt 1980 · S/N 172RG0596 N6249WWall Scott R · Franksville, WIBuilt 1964 · S/N 28-20295 N624APThomas Lucas G · Beebe, ARBuilt 1978 · S/N 274-78 N624AQHigh Flight Academy LLC · Allison Park, PABuilt 1984 · S/N 28-8416122 N624BTJespersen Barry W · Olympia, WAS/N 91944 N624DGRv4 Adventures Inc · Wilmington, DEBuilt 1998 · S/N 3499 N624FTFlorida Institute Of Technology · Melbourne, FLBuilt 1979 · S/N 28-7916446 N624MSMcclure George E Jr · Nipomo, CABuilt 2001 · S/N 25123 N624RCJeffrey Guy · Centerburg, OHBuilt 1993 · S/N 318 N624SStoro Eddy · Netarts, ORBuilt 2000 · S/N 80620

Back to AD 79-10-03 R2