Registered aircraft · 108,428

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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.

N1574PSouthern Seaplane Inc · Belle Chasse, LABuilt 1976 · S/N 21061258 N1574SAdk Global LLC · Hollywood, FLBuilt 1962 · S/N CD-530 N1574XQuinones Roland · Plano, TXS/N 28R-7535338 N1574ZFernando Espinosa Aviation LLC · Helena, MTBuilt 1961 · S/N CD-432 N15753Bischoff Daniel C · Camano Island, WABuilt 1972 · S/N 28-7325152 N15755Fitzgerald Lee M · High Springs, FLBuilt 1973 · S/N 28-7325154 N15757Dickinson Ross · Tilden, TXBuilt 1972 · S/N 28-7305137 N15759Williams Sean Aaron · Whiteland, INBuilt 1973 · S/N 28-7325155 N1575CMeierotto Martin A · Two Rivers, AKBuilt 1953 · S/N 30275 N1575RSpurlock Daniel C · Harrogate, TNS/N AA5B-0075 N1575SSkyward Flying LLC · Goshen, INBuilt 1975 · S/N 18264374 N1575VMissouri Reliability Services LLC · Maryville, MOBuilt 1974 · S/N 17263675 N15760Been Flyin LLC · Colchester, CTBuilt 1972 · S/N 28-7325157 N15762Carlevaro Bruce C · Edmond, OKBuilt 1972 · S/N 28-7305140 N15763First Pryority Bank · Pryor, OKBuilt 1972 · S/N 28-7305141 N15764Leyva Jose Luis · New Smyrna Beach, FLBuilt 1972 · S/N 28R-7335089 N15765Moulder Tyler Dane · Huntsville, ALBuilt 1972 · S/N 28R-7335090 N15768Khleb Hub LLC · Palm Coast, FLBuilt 1973 · S/N 28-7325156 N1576HBloom Timothy S · Chugiak, AKBuilt 1977 · S/N 18503309 N1576JInspire Aviation LLC · Magnolia, TXBuilt 1967 · S/N 28-23982 N1576MSkyline Aviation Services LLC · Miramar, FLBuilt 1977 · S/N 21061948 N1576WPowis Michael P · Oak Grove, MOBuilt 1972 · S/N D-9350 N1576ZOzarks Auto Show Inc · Hollister, MOBuilt 1961 · S/N TC-221 N15770Collett Palmer · Frankfort, KYBuilt 1972 · S/N 28-7325159 N1577CDunn William A · Dedham, MES/N 30277 N1577ESeibert Lynn K · Fresno, CAS/N 1131 N1577GCohen Mark R · Dallas, TXBuilt 1967 · S/N CD-1103 N1577HKing Wayne T · Anchorage, AKBuilt 1977 · S/N 18503310 N1577LKoga Corp Inc · Las Vegas, NVS/N E-825 N1577RGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1981 · S/N 278154026 N1577WDshannon Products Ltdregistered · Buffalo, MNBuilt 1972 · S/N E-333 N1577ZAthuil Philippe · Beverly Hills, CABuilt 1961 · S/N D-6878 N15782Crane Austin · Redlands, CAS/N 28-7305144 N15783Pretorius Anthony · Easley, SCBuilt 1972 · S/N 28-7305145 N15788Chafin Gerald III · Mountain Home, ARS/N 32-7300016 N15789Sidc2 LLC · North East, MDBuilt 1973 · S/N 34-7350094 N1578CImhof Air LLC · Ferndale, WABuilt 1953 · S/N 30278 N1578LBaloian Packing Co Inc · Fresno, CABuilt 1976 · S/N E-826 N1578ZProctor Brian S · Leesburg, TXBuilt 1961 · S/N D-6877 N1579JTornow Saxon Michael · Highland, UTS/N 28-23987 N1579LEvans Christopher A · Lynden, WABuilt 1976 · S/N D-9863 N1579MGospel To The Nations Ministries Inc · Dayton, OHBuilt 1975 · S/N 18264377 N1579RSkelton James P Jr · Lithia Springs, GABuilt 1975 · S/N AA5B-0079 N1579TPedro Christopher M · Dushore, PABuilt 1997 · S/N 5055 N1579WTilden Jeffrey Dennis · Columbus, INBuilt 1972 · S/N CD-1289 N1579XBuchberger Robert J · Plainfield, WIBuilt 1975 · S/N 28-7510111 N1579ZQueen Mark Allen · Adel, GABuilt 1961 · S/N CD-434 N157AMPhotofax Inc · Gilberts, ILFirst renewal noticeBuilt 2001 · S/N 2157 N157ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010053 N157CCWhite David W · South Fulton, TNS/N 310I0157

Back to AD 2007-04-19 R1