Skip to content

Registered aircraft · 25,368

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.

N9505HFinal Approach Aviation LLC · Danville, CABuilt 1975 · S/N 17266185 N9505MLeahy Michael P · Downers Grove, ILBuilt 1966 · S/N 670082 N9507LBatra Sanjeev · Roseville, CABuilt 1986 · S/N 17276566 N9507MSanford Russell G · Brooks, GABuilt 1966 · S/N 670084 N9507SKoppie Gary J · Emmetsburg, IABuilt 1965 · S/N 7ECA-254 N9508BRegistered aircraftBuilt 1981 · S/N 172RG0842 N9509GMid Continent Aircraft Corp · Hayti, MOBuilt 1974 · S/N 18801508T N9509SChambers David R · Centre, ALS/N 259 N950ACRed Carpet Aviation LLC · Carlsbad, CABuilt 1983 · S/N 17276058 N950DRRjc Skyhawk LLC · Middletown, DES/N 17268169 N950MEN950me LLC · Manassas, VABuilt 1976 · S/N 17266539 N950SRAcme Aero LLC · Kingman, KSBuilt 1979 · S/N 21063698 N95103Shelton Aviation Inc · Christiansburg, VABuilt 1984 · S/N 15285849 N9510HRegistered aircraftBuilt 1975 · S/N 17266188 N9510JOrange County Mosquito Control District · Orange, TXBuilt 1981 · S/N 18803814 N9510LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276568 N9510SStory Brian J · Noblesville, INS/N 7ECA-275 N9511MBenjamin Joseph · Erie, COBuilt 1966 · S/N 670088 N95122Mcnamara Kevin M Jr · East Aurora, NYBuilt 1984 · S/N 15285852 N9512HTracy Patrick J · Maddock, NDBuilt 1975 · S/N 17266190 N9512MBible Larry · Mount Pleasant, TXBuilt 1966 · S/N 670089 N9512YPalmer George J III · Orlando, FLBuilt 1981 · S/N 21064533 N9513BLong Michael A · Grand Lake, COBuilt 1981 · S/N 172RG0844 N9513HHigh Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17266191 N9513MHangar9llc · Queen Creek, AZBuilt 1966 · S/N 670090 N9514HFrerichs John E · Gurley, ALBuilt 1975 · S/N 17266192 N9514MHolen Benjamin E · Ketchum, IDBuilt 1966 · S/N 670091 N9514TColl Valdes Jeffrey A · Boise, IDBuilt 1978 · S/N 38-78A0122 N95159Kinne Dagmar · Woodburn, ORBuilt 1984 · S/N 15285860 N9515BGrason Aviation LLC · Appleton, WIBuilt 1981 · S/N 172RG0846 N9515MReid Stephen M · Gardner, KSBuilt 1966 · S/N 670092 N9516MBurrell John Eric · Springfield, VABuilt 1966 · S/N 670093 N9518MPritchard Benjamin Ross · Cedar Rapids, IABuilt 1966 · S/N 670095 N9519MNiemeyer John P · Cortland, NEBuilt 1966 · S/N 670096 N9519SKs Flying Club Inc · Manhattan, KSBuilt 1965 · S/N 7ECA-257 N951AGAcn951ag LLC · Worthington, OHBuilt 1999 · S/N 850-99 N951HCUsweixin · Sheridan, WYBuilt 1980 · S/N 172RG0282 N9520MCoker Steve L Jr · Tyler, TXBuilt 1966 · S/N 670097 N9520SPease Richard C · Snow Camp, NCBuilt 1965 · S/N 8 N9521HJordan Recreation Development LLC · Clinton, TNBuilt 1975 · S/N 17266197 N9522HUrbas Robert M · Rockford, ILBuilt 1975 · S/N 17266198 N9522LYellow Jacket Flying Club Inc · Atlanta, GAFirst renewal noticeS/N 17276570 N9522MCrouch Mark W · Cumming, GABuilt 1966 · S/N 670099 N9522TVeillon Joseph B · Alexandria, LAS/N 555 N9523HVictor James A · Kingsville, OHBuilt 1975 · S/N 17266199 N9523SHogan Edison D · Macon, ILBuilt 1965 · S/N 95 N9525MVaughn Robert Bruce · Macon, GABuilt 1966 · S/N 670102 N9525TPorte Elvis · Miami, FLS/N 38-78A0125 N9526BWildenberg Ronald · Beloit, WIBuilt 1981 · S/N 172RG0855 N9526HAbove The Haze LLC · San Lorenzo, CABuilt 1975 · S/N 17266201

Back to AD 80-25-07 R1