Skip to content

Registered aircraft · 6,915

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.

N4551XLewis Michael A · Alexandria, VABuilt 1975 · S/N 28R-7635075 N4552JAg Air Squadron One LLC · Saint Joseph, ILBuilt 1968 · S/N 28R-30413 N4552QGrand Air LLC · Granby, COS/N 28R-7703127 N4552XWozniak Robert F · Baltimore, MDBuilt 1975 · S/N 32R-7680027 N4555FRegistered aircraftBuilt 1976 · S/N 28R-7635416 N4555TJb Aviation LLC · Mason City, IAS/N 28R-7235087 N4556QChief Aviation Services LLC · Ferriday, LAS/N 32R-7780333 N4557XPrime Property Investments LLC · Pevely, MOBuilt 1975 · S/N 32R-7680028 N4558JDaprile Jonathan · Port Charlotte, FLBuilt 1968 · S/N 28R-30418 N4559JBolduc Michael A · Strong, MEBuilt 1968 · S/N 28R-30419 N4559XJlp Flying LLC · Clewiston, FLBuilt 1975 · S/N 28R-7635089 N455LPhoenix East Aviation LLC · Daytona Beach, FLS/N 34-7450172 N455USHickerson Timmy D · Greenfield, INS/N 34-8170003 N4561QDew Thomas E · Oro Valley, AZBuilt 1977 · S/N 32R-7780334 N4562XVenture West LLC · Mesa, AZBuilt 1975 · S/N 28R-7635078 N4563FOcean City Flying Club Inc · Newport, RIBuilt 1976 · S/N 32R-7680460 N4563JPilling Ian M · Bonita, CABuilt 1968 · S/N 28R-30425 N4563VMercer Alexander David · San Diego, CABuilt 1958 · S/N 24-129 N4563XTriple D LLC · Scotland, PABuilt 1975 · S/N 32R-7680029 N4564FStern Aviation Inc · N Fort Myers, FLBuilt 1976 · S/N 28R-7635454 N4564XMulti-Time LLC · Jacksonville, FLS/N 34-7670073 N4565TSchendel Daryl R · Barstow, CABuilt 1972 · S/N 28R-7235094 N4566JDifilippo Antonio O · Spring Church, PABuilt 1968 · S/N 28R-30429 N4566XZihala William · North Little Rock, ARBuilt 1975 · S/N 28R-7635079 N4567TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250136 N456PBooth Donald V · Denison, TXS/N 24-3276 N456RRAir America Flight Center LLC · Daytona Beach, FLBuilt 1976 · S/N 28R-7635457 N4573JRoss James A · Barrington, RIS/N 28R-30438 N4574JWakefield Aircraft LLC · Cooperstown, NDBuilt 1968 · S/N 28R-30439 N4574TBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 34-7250137 N4574XClassic Air Aviation LLC · Mesa, AZBuilt 1975 · S/N 34-7670075 N4576XElon Aviation LLC · Burlington, NCBuilt 1975 · S/N 28R-7635081 N4578TMeditz Robert S · Chalfont, PABuilt 1972 · S/N 28R-7235097 N4579TNavajo Air LLC · Scottsdale, AZBuilt 1972 · S/N 28R-7235098 N4581JN634mm LLC · Pelham, ALBuilt 1968 · S/N 28R-30450 N4582JTew-Mac Aviation · Tewksbury, MABuilt 1968 · S/N 28R-30451 N4583TKeppers Richard W · Alexandria, VABuilt 1972 · S/N 28R-7235099 N4584JBradley Cody C · Auburn, NEBuilt 1968 · S/N 28R-30454 N4586XMccardle Michael L · Houston, TXBuilt 1975 · S/N 28R-7635086 N45888D-Five Holdings Group LLC · Vidor, TXBuilt 1963 · S/N 24-3453 N4588JSierra Hotel Fliers LLC · Lexington Park, MDBuilt 1968 · S/N 28R-30459 N4589JArthurs Nathanael L · Indiana, PABuilt 1968 · S/N 28R-30462 N4590JEpic Aviation Inc · New Smyma Beach, FLBuilt 1968 · S/N 28R-30463 N4590TOdonald John C · Greenville, MIBuilt 1972 · S/N 28R-7235102 N4594XAdventure Ventures LLC · Salem, CTBuilt 1975 · S/N 28R-7635088 N4595JPetesch Andrew L · Meriden, KSBuilt 1968 · S/N 28R-30471 N4595XManoli Louis Charles · Wampum, PABuilt 1975 · S/N 32R-7680035 N4597TArsenault Ronald L Jr · Newton, ALBuilt 1972 · S/N 28R-7235104 N4598JPerricone David M · Webster, NYBuilt 1968 · S/N 28R-30475 N4599JMidway Enterprises Inc · Wilmington, DES/N 28R-30477

Back to AD 97-01-01 R1