Skip to content

Registered aircraft · 25,370

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.

N42CWHollywood Of The South Flight School Ltd · Decatur, GABuilt 1979 · S/N P21000228 N42GVBlahnik Vance Thomas Trustee · Eden Prairie, MNBuilt 1978 · S/N R18200219 N42JAJersey Aero Club Inc · Lakewood, NJBuilt 1976 · S/N 17267383 N42VVSilverhawk Aviation Academy Oregon LLC · Ontario, ORS/N 172RG0703 N42WBCity Of Mesa Arizona · Mesa, AZBuilt 1981 · S/N P21000667 N4300RCab Air Inc · Columbia, NJBuilt 1974 · S/N 17263054 N4301QSchneider Frederick I · Sault Sainte Marie, MIBuilt 1971 · S/N 17260201 N4301RMeggers Roger D · Baker, MTBuilt 1974 · S/N 17263055 N4303QHobart Aviation Inc · Akron, OHBuilt 1971 · S/N 17260203 N4304QProfessional Aviation Inc · Dalton, GAS/N 17260204 N4304RMoore Robby J · Salem, ORBuilt 1978 · S/N R18200587 N4305HTylski Aero Services LLC · Valley, NEBuilt 1979 · S/N 24-0788 N4307RMcmath Don · Collinsville, OKBuilt 1974 · S/N 17263060 N4308QN4038q LLC · Merritt Island, FLBuilt 1971 · S/N 17260208 N4309QCamp Harold S Jr · Bossier City, LABuilt 1971 · S/N 17260209 N430DBIkard James C · Shelbyville, TNBuilt 1979 · S/N R18201386 N430FSCustom Air International LLC · Homestead, FLBuilt 1978 · S/N 17271355 N4310QRonceverte Fliers Incorporated · Asbury, WVBuilt 1971 · S/N 17260210 N4311QLink John · West Milford, NJBuilt 1971 · S/N 17260211 N4312RHorizon Group Inc Trustee · Boca Raton, FLBuilt 1974 · S/N 17263065 N4313RStauffer Kurt A · Belleville, PABuilt 1974 · S/N 17263066 N4314QRafinski Marcus · San Juan, PRBuilt 1971 · S/N 17260214 N4315QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1971 · S/N 17260215 N4315RDuffys Aircraft Sales And Leasng Inc · Neillsville, WIBuilt 1974 · S/N 17263068 N4316RMarston Charles T · New Bern, NCBuilt 1974 · S/N 17263069 N4317QPerera Nandana L · Logan, OHBuilt 1971 · S/N 17260217 N4317RSam Aviation LLC · Long Beach, CAS/N 17263070 N4318RBeaulieu Steven · Georgetown, DEBuilt 1974 · S/N 17263071 N4319EAcevedo Adriel · San Antonio, TXBuilt 1978 · S/N 38-78A0548 N431ARegistered aircraftBuilt 1976 · S/N 17265942 N431MARegent Trust Corporation Trustee · Wichita, KSBuilt 2022 · S/N 1200-2022 N431SAArgotsinger Michael · Wichita, KSBuilt 2004 · S/N 952-2004 N4321QW H Flying Club Inc · Kingston, MIS/N 17260221 N4322H4322h Rescue LLC · Oakland Park, FLS/N 24-0822 N4322RKing Air Charter LLC · Zanesville, OHBuilt 1978 · S/N R18200590 N4323HRucker Edward A · Longview, TXS/N 24-0704 N4323QWausau Flying Service Inc · Wausau, WIBuilt 1971 · S/N 17260223 N4323RMy Flight LLC · Cypress, TXBuilt 1974 · S/N 17263076 N4324RShadle James A Jr · Gig Harbor, WABuilt 1974 · S/N 17263077 N4325QBeier Mark E · Sylvania, GABuilt 1971 · S/N 17260225 N4325RGaruda Aviation Inc · Miami, FLBuilt 1974 · S/N 17263078 N4326QStar Fleet Aviation LLC · Bisbee, AZBuilt 1971 · S/N 17260226 N4327EPegasus Enterprises LLC · Overton, NVBuilt 1978 · S/N 38-78A0553 N4327QFackler Aviation Services LLC · Clearwater, FLBuilt 1971 · S/N 17260227 N4328HCalabretta Charles J · Hanford, CABuilt 1978 · S/N 24-0708 N4328QBetzner John C · Medway, MABuilt 1971 · S/N 17260228 N4329QElfers Brian K · Colfax, WAFirst renewal noticeBuilt 1971 · S/N 17260229 N432AEArnold Neil · Caro, MIBuilt 1968 · S/N 690019 N432MJ43rd Aviation Flying Club Inc · Wethersfield, CTBuilt 1983 · S/N 241413 N4330EDooley Jon S · Greensburg, INS/N 38-78A0555

Back to AD 80-25-07 R1