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.

N18RKJacksonville Twin Comanche LLC · Kalispell, MTBuilt 1979 · S/N 34-7970151 N18TPPotter Todd J · Warrens, WIBuilt 1979 · S/N 34-7970431 N1901PTurner William D · Southaven, MSBuilt 1958 · S/N 24-183 N1906HTriplett Gregory L · Holden, MOBuilt 1977 · S/N 32R-7780199 N1908HSandlin James B · Surgoinsville, TNBuilt 1977 · S/N 32R-7780201 N190FTWestchester Flying Club Inc · Purchase, NYBuilt 1978 · S/N 28R-7837245 N1912THillman Motors Inc · Winter Haven, FLBuilt 1971 · S/N 28R-7135130 N1915TAeromx LLC · West Jefferson, OHBuilt 1971 · S/N 28R-7135132 N191BCZabrosky Air LLC · Cedar Hills, UTBuilt 1973 · S/N 28R-7435088 N1927HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1977 · S/N 28R-7737017 N1939HChicas-Terrill Roger Daniel · Anaheim, CABuilt 1977 · S/N 28R-7737018 N1940TC140 Co LLC · Milton, FLBuilt 1971 · S/N 28R-7135138 N1946TDja Aviation LLC · Middletown, DEBuilt 1971 · S/N 28R-7135140 N1952HAmpersand Air Inc · Camp Hill, PABuilt 1977 · S/N 28R-7703041 N1952TLeardo Inc · Plano, TXS/N 28R-7135185 N1955HDriskell Cpa Firm Pc · Birmingham, ALBuilt 1977 · S/N 32R-7780209 N1956RCorrech Jose Pedro · Cape Coral, FLBuilt 1971 · S/N 39-85 N1956SRegistered aircraftBuilt 1975 · S/N 28R-7535164 N1957TPipers Are Still Better LLC · Carson City, NVBuilt 1971 · S/N 28R-7135177 N1959PTanner Greg L · Bend, ORBuilt 1959 · S/N 24419 N1960TRay Steven B · Fort Collins, COBuilt 1971 · S/N 28R-7135173 N1963TCondor Aero Club Inc · Zelienople, PABuilt 1971 · S/N 28R-7135192 N196SQBay Land Aviation Inc · Salisbury, MDBuilt 1977 · S/N 32R-7780259 N1972BPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1972 · S/N 34-7250173 N1972KBachtac Aviation LLC · Clarksville, TXBuilt 1977 · S/N 32R-7780030 N1980HEf Aviation LLC · Cape Coral, FLS/N 28R-7703044 N1982HWasley David L · Harwinton, CTBuilt 1977 · S/N 32R-7780212 N1983HGroeteke Robert W · Ravenna, NEBuilt 1977 · S/N 32R-7780213 N1986HTraining Planes LLC · Tampa, FLS/N 28R-7737022 N1987HFour C Sons Inc · Kersey, COBuilt 1977 · S/N 28R-7703046 N1988HKingdom Flying LLC · Inman, SCBuilt 1977 · S/N 32R-7780214 N1989HHogan Thomas J · San Diego, CABuilt 1977 · S/N 34-7770164 N1989TJ3bar Pilot Services LLC · Garden City, KSBuilt 1971 · S/N 28R-7135203 N198TBHonore Breen Aviation LLC · Allegan, MIBuilt 1980 · S/N 348070032 N1993TDenali Management Inc · Encino, CABuilt 1971 · S/N 28R-7135211 N1994THelisur USA LLC · Pembroke Pines, FLS/N 28R-7135187 N1996HLord Alan T · Reynoldsburg, OHBuilt 1977 · S/N 28R-7737023 N1997HScarry Daniel · San Luis Obispo, CABuilt 1977 · S/N 28R-7703047 N199JBOew Aviation LLC · Sumter, SCBuilt 1971 · S/N 28R-7135100 N199JTPena Rivera Luis A · Zephyrhills, FLBuilt 1960 · S/N 24-2323 N199PKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-35694 N19BAgricultural Investors LLC · Jacksonville, FLBuilt 1977 · S/N 34-7770293 N19MBDg Aircraft LLC · Lemont Furnace, PAS/N 34-7970031 N19PAAkradi Parviz Trustee · Laguna Niguel, CABuilt 1977 · S/N 28R-7803129 N19RDDennison Ronald Walton Trustee · San Jose, CABuilt 1966 · S/N 24-4597 N19SERegistered aircraftBuilt 1968 · S/N 28R-30525 N19TPTwv Air LLC · Ewing, NJBuilt 1978 · S/N 34-7870383 N19VSGardner James R · League City, TXBuilt 1963 · S/N 30-144 N1JDAero Aircraft 10 LLC · Jacksonville, FLBuilt 1972 · S/N 34-7250103 N1JQJacquot Daniel C · Colorado Springs, COBuilt 1965 · S/N 24-4327

Back to AD 97-01-01 R1