Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N2298MLeft Seat Flyers LLC · Mount Pleasant, SCBuilt 1977 · S/N 32R-7880062 N2298QGalaxy Enterprises LLC · Holdrege, NEBuilt 1977 · S/N 34-7770185 N229DRSpecialty Veterinary Services LLC · Monteverde, FLBuilt 1976 · S/N 28R-7635320 N229TYSchilling Aviation LLC · Britton, MIBuilt 1962 · S/N 24-3339 N22CJCleveland Adam · Abilene, TXBuilt 1965 · S/N 30-905 N22JLWasson James L · Tyler, TXBuilt 1972 · S/N 34-7250198 N22KSWhite Brian · Forsyth, GABuilt 1972 · S/N 28R-7235019 N22LMRd Aire LLC · Opelika, ALBuilt 1963 · S/N 30-56 N22PWGoldsboro Flight Club LLC · Faison, NCBuilt 1975 · S/N 34-7570144 N22RNTre Ventures LLC · Mount Olive, NCBuilt 1974 · S/N 28R-7535010 N22SGAir Flight Enterprises Inc · South Daytona, FLS/N 30-1718 N22TKGreen Theodore G · Franklin, WIBuilt 1963 · S/N 24-3541 N2308TBugarchich Christopher Z · Stratford, CTBuilt 1971 · S/N 28R-7135200 N230MJVne LLC · Sheridan, WYS/N 30-1302 N230SWMartin Co · Tyrone, GABuilt 1971 · S/N 39-37 N2311TAlanair LLC · Red Hook, NYBuilt 1971 · S/N 28R-7135197 N2317TShirley Aviation LLC · Alexandria, VABuilt 1971 · S/N 28R-7135208 N2321THobson Joseph C · Beverly Hills, FLBuilt 1971 · S/N 28R-7130009 N2325TFlorida State College At Jacksonville · Jacksonville, FLBuilt 1971 · S/N 28R-7135201 N2327TSale Reported · Hampton, GASale reportedBuilt 1971 · S/N 28R-7135216 N2328TElite Flight LLC · Lordstown, OHBuilt 1971 · S/N 28R-7135217 N232YPGill Joshua Daniel · Tucson, AZS/N 24-3401 N2330TSteele Jackie L · London, KYS/N 28R-7130010 N2333TNottingham Jeffrey A · Locust Grove, GABuilt 1971 · S/N 28R-7135204 N2334MSunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 28R-7837083 N2336TN2336t Airplane Partnership LLC · Wilmington, DEBuilt 1971 · S/N 28R-7135209 N2339TK E F Enterprises Inc · Plymouth, MABuilt 1971 · S/N 28R-7135227 N2340TGrillo Donald · Green Cove Springs, FLBuilt 1971 · S/N 28R-7135228 N234BGLangeland Thomas Arthur · San Antonio, TXBuilt 1965 · S/N 30-909 N234FYVee Two Inc · Merritt Island, FLBuilt 1978 · S/N 347870428 N234NCIal Corp · Lewes, DEBuilt 1973 · S/N 34-7350146 N234TGAvionicos Corp · Sarasota, FLS/N 34-8070234 N2350MCampbell J Bryce · Stillwater, OKBuilt 1977 · S/N 28R-7803125 N23585Smile By Air LLC · Columbus, OHBuilt 1975 · S/N 32R-7680007 N23653Gales Charles R · Cleverdale, NYBuilt 1968 · S/N 28R-30691 N236CFGriswold Joshua P · Los Angeles, CABuilt 1976 · S/N 34-7770091 N2394MOld Buzzard Ltd · Columbus, OHBuilt 1977 · S/N 28R-7837085 N23BMAxiom Development And Consulting LLC · Atlanta, GABuilt 1959 · S/N 24-1118 N23JCJet & Rotor Aviation LLC · Sacramento, CABuilt 1980 · S/N 348070121 N23LGGist Thomas Hottel III · Little Rock, ARBuilt 1959 · S/N 24-832 N23MCFilm Fliers Inc · Orlando, FLBuilt 1976 · S/N 32R-7680190 N23MGNewhall William G · Longmont, COBuilt 1971 · S/N 39-28 N23NVAvk Air LLC · Harvest, ALBuilt 1977 · S/N 32R7780373 N23RDRegistered aircraftS/N 30-469 N23RWTirpak Garrett J · Daphne, ALBuilt 1977 · S/N 32R-7780535 N240LHWitt Aaron K · Hooker, OKBuilt 1966 · S/N 30-1240 N2411MAltshuler David · Cambridge, MAS/N 28R-7803126 N2412MChristensen Broadcast Group Inc · Watertown, SDBuilt 1977 · S/N 28R-7803127 N2414QErhart Jeffery R · Zephyr Cove, NVS/N 32R-7780246 N2416MSun South Aviation LLC · Wilmington, DEBuilt 1977 · S/N 32R-7880063

Back to AD 97-01-01 R1