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.

N2080JWoelfel Tim A · Madisonville, TXBuilt 1978 · S/N T18803370T N20811Rtd Aviation LLC · Hillsborough, NJBuilt 1974 · S/N 17263843 N20823American Patrols Inc · Midland, TXBuilt 1974 · S/N 17263848 N20825Sussman Stanley M · New Castle, DEBuilt 1974 · S/N 17263849 N2082JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N T18803372T N20834Climb Maintain LLC · Morrisville, MOBuilt 1974 · S/N 17263850 N20837Mjm Enterprise Holdings LLC · Drexel, MOBuilt 1974 · S/N 17263851 N2083QCardinal N2083q LLC · Churchville, PABuilt 1974 · S/N 177RG0483 N20843St Louis Flying Club Inc · Ellisville, MOBuilt 1974 · S/N 17263853 N2084EBuchholz Steve DBA · Clarkston, MIBuilt 1978 · S/N 17271148 N20858Vintage Flyers Inc · Napa, CABuilt 1974 · S/N 17263857 N20865Agasair LLC · East Hampton, NYBuilt 1974 · S/N 17263859 N2086QMillner Paul · Berkeley, CABuilt 1974 · S/N 177RG0486 N20871High Flight Academy LLC · Allison Park, PABuilt 1975 · S/N 17263862 N20876Ogalalla Land & Cattle Ltd · Douglas, WYS/N 17263863 N2087EPcs Aviation LLC · La Canada, CABuilt 1978 · S/N 17271150 N2088VMad Scientist Aviation LLC · Wilmington, DEBuilt 2002 · S/N 465-2002 N20891Morristown Flying Service Inc · Talbott, TNBuilt 1974 · S/N 17263867 N2089ESkyhawk N2089e Ltd · Deerfield, ILBuilt 1978 · S/N 17271151 N2089QKelly Daniel W · Conway, SCBuilt 1974 · S/N 177RG0489 N2089STxt Aviation LLC · Deland, FLS/N R18201299 N208ATLeciejewski Darrell K · Mc Alpin, FLBuilt 1976 · S/N 17268379 N2090QRawls Mike E · New Waverly, TXS/N 177RG0490 N2090YKilbey Bryan E DBA · Defuniak Springs, FLS/N 177RG1106 N2091QJohnson Earl V · Andalusia, ALBuilt 1974 · S/N 177RG0491 N20921Brigham David F · Elliottsville Twp, MEBuilt 1974 · S/N 17263869 N20932Registration Pending · Hammond, LARegistration pendingBuilt 1974 · S/N 17263872 N20934Fly Skyhawk Llp · Galena, OHBuilt 1974 · S/N 17263874 N20940Cirrus Flight Operations Inc · Minneapolis, MNBuilt 1974 · S/N 17263876 N20951Strevels Stephen M · Knoxville, TNBuilt 1974 · S/N 17263879 N20954Hardin John M · Terrell, TXS/N 17263881 N20965Reich Aviation LLC · Loudon, TNBuilt 1974 · S/N 17263883 N2099QTice William · Lancaster, MABuilt 1974 · S/N 177RG0499 N209DPBke Air LLC · Newnan, GABuilt 1977 · S/N 17270158 N209HVAnderson Scott · Salem, ORBuilt 1979 · S/N 17272302 N209JFStock James D · Deer Park, WABuilt 1967 · S/N 76 N209KSSchneider Kerry · Alpine, WYS/N P21000560 N20AAGrand River Aviation LLC · Kremmling, COBuilt 1968 · S/N 17256596 N20AVRocco Leroy · Ceresco, MIBuilt 1976 · S/N 177RG-0888 N20AXHehmann Richard J · Belleville, ILS/N 177RG1160 N20CTN20ctid LLC · Pocatello, IDBuilt 1978 · S/N 152-81952 N20CUCosta Flying Service Inc · Painted Post, NYBuilt 1980 · S/N 172RG0323 N20DKFlight Surgeon LLC · Fayetteville, ARBuilt 1976 · S/N 17266836 N20EHUnzicker Keith R · Benson, ILBuilt 1966 · S/N 1090 N20HTRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1969 · S/N 17258306 N20JXWorld Wide Air & Sea Inc · Wilton, NHBuilt 1990 · S/N 24-3204 N20MUOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271496 N20PWWingnuts Aviation Inc · Franklin, INBuilt 1979 · S/N 24-0900 N20RHStoltzfus John F Jr · Strasburg, PAS/N 172-68331 N20RTTyson Richard E · Barton, FLBuilt 1966 · S/N 3309

Back to AD 80-25-07 R1