Skip to content

Registered aircraft · 25,369

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.

N62283Flight School Of Gwinnett Inc · Lawrenceville, GAS/N 17275244 N62287Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17275247 N6228KSunset Leasing Inc · Sarasota, FLBuilt 1980 · S/N 17274175 N62296Sale Reported · Signal Hill, CASale reportedS/N 17275249 N6229CClause James W Trustee · La Quinta, CABuilt 1979 · S/N 21063838 N6229NTran Daniel T · Aliso Viejo, CABuilt 1980 · S/N 18267805 N6229UMonte Sam A · Bend, ORBuilt 1962 · S/N 2068 N622ACAj Aircraft LLC · Yarmouth, MEBuilt 1998 · S/N 810-98 N622CBBestland Roger J · Webster, MNBuilt 1995 · S/N 760-95 N622DLColorado Aircraft Corp · Watkins, COBuilt 1975 · S/N 17264853 N622DXChang Daniel H · La Crescenta, CABuilt 1979 · S/N 24-0851 N622EHaggerty Russell P · Bethpage, NYBuilt 1971 · S/N 17260059 N622GPTwenty Two Ashford LLC · Brentwood, TNBuilt 1981 · S/N 17274593 N622RFFrench Robert S · Sunnyvale, CABuilt 1978 · S/N 15282769 N6230DUsda Aphis Wildlife Services · Cedar City, UTBuilt 1979 · S/N 17272648 N6230QEast Hill Flying Club Inc · Ithaca, NYBuilt 1981 · S/N 15285205 N6230URutter Bruce W · Ralph, MIBuilt 1962 · S/N 2069 N6231EMiller Edward P · Northfield, MNBuilt 1978 · S/N 17272001 N6231FH & F Aviation Inc · Labelle, FLS/N 17273170 N6232DJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17272650 N62332Skylens LLC · Hammond, LABuilt 1981 · S/N 17275251 N6233DGrauert Ritter Trustee · Van Nuys, CAS/N 17272651 N62348Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17275254 N6234UNabert Maher K · Augusta, GABuilt 1962 · S/N 2073 N62350Flycarolina LLC · Concord, NCBuilt 1981 · S/N 17275255 N62354Skywarrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17275256 N6237UCardoza Roger A · Fairbanks, AKBuilt 1962 · S/N 2076 N6237YStrategic Sourcing Solutions Inc · Topeka, KSBuilt 1981 · S/N 21064303 N6239DAerial Precision LLC · Entiat, WAS/N 17272657 N6239FEckert Ted · Cedar Creek, TXBuilt 1979 · S/N 17273172 N6239YBlue Horizon Aviation LLC · New Concord, OHBuilt 1981 · S/N 21064304 N623AFFleetshares N623af Inc · Lincoln, NES/N 15280841 N623PADsr Cherokee 180 LLC · Dallas, TXBuilt 1985 · S/N 15286002 N62405Flight School Of Gwinnett Inc · Lawrenceville, GABuilt 1981 · S/N 17275263 N62407Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17275264 N6240ACraig Matthew · Peachtree City, GAS/N 38-78A0351 N6240ULewis Ricky Ll · Cisco, TXBuilt 1962 · S/N 2079 N6241UPalmer Charles L · Huntington Beach, CABuilt 1962 · S/N 2080 N62425Dodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 17275267 N62429Fowler Cary D · Hayti, MOBuilt 1981 · S/N 17275268 N6243CDcd Aircraft Sales LLC · Leesburg, FLS/N 21063841 N6243QHanzawa George K · Honolulu, HIBuilt 1981 · S/N 15285208 N62444Ditmer Jack L Jr · Troy, OHBuilt 1981 · S/N 17275271 N62447Tri-State Flg Club Inc · Huntington, WVBuilt 1981 · S/N 17275272 N6244UHawthorn Seth A · New Vienna, OHBuilt 1962 · S/N 2083 N62457Pisarello William J · Sebring, FLBuilt 1981 · S/N 17275275 N6245DJeffery & Weiss Holdings LLC · Long Beach, CABuilt 1979 · S/N 17272661 N6245SFillmore Aviation LLC · South Saint Paul, MNBuilt 1980 · S/N R18201653 N6245UMcgee Joel M · Woodford, VAS/N 2084 N62475Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275279

Back to AD 80-25-07 R1