OpenAirDocs.org
AD 2009-10-09 R2

Registered aircraft · 8,563

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
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:2009-10-09-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-10-09-R2')
  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.

N1391QPark Derek B · Lyons, GABuilt 1971 · S/N 15072691N1392QRegistered aircraftBuilt 1971 · S/N 15072692N1393QBeitel Ronald Lee · Rochester, MNBuilt 1971 · S/N 15072693N1394QDaugherty Keith C · Venus, PABuilt 1971 · S/N 15072694N13BALong Arthur · Colonie, NYBuilt 1975 · S/N 15077300N13DRSchuler Edward A Jr · Hamden, CTBuilt 1966 · S/N 15064816N13EAHood Norman R · Austin, TXBuilt 1977 · S/N 15279914N1409QDjz Aviation LLC · Kalispell, MTBuilt 1971 · S/N 15072709N140MAMindy Limited LLC · Muscatine, IABuilt 1970 · S/N 15072399N140RWTarara Chad L · Webster, MNBuilt 1973 · S/N 15074478N1410GSierra-Mike LLC · Springdale, ARS/N 15073205N1412QOconnor Melanie Faith · Flagler Beach, FLBuilt 1971 · S/N 15072712N1413QWolf John C · Bethel, PABuilt 1971 · S/N 15072713N1414QForsman Robert J · Jber, AKBuilt 1971 · S/N 15072714N1417QSteinke William A · Mount Juliet, TNBuilt 1971 · S/N 15072717N1420QSweet Sanford L · Tawas City, MIS/N 15072720N1424QPadilla Cresencio I · Big Spring, TXBuilt 1971 · S/N 15072724N1426QJr Imaging Logistics Inc · Pasco, WABuilt 1971 · S/N 15072726N1429QReeves Richard E · Lincoln, NEBuilt 1971 · S/N 15072729N142EZAttacoa Air LLC · Juneau, AKBuilt 1972 · S/N 15074086N142SBSopha Kim A · Poynette, WIBuilt 1969 · S/N 15070717N1430QGearhart Robert H · Three Rivers, MIBuilt 1971 · S/N 15072730N1435QWeaver G Thomas · Fairbanks, AKBuilt 1971 · S/N 15072735N1437QPeyton Jerry L · Sebeka, MNBuilt 1971 · S/N 15072737N143AKLipinski Glen E · Chandler, AZS/N 15074168N143DKReynolds Terry J · Phoenix, AZS/N 15073020N1440GSierra-Mike LLC · Springdale, ARS/N 15072955N1440QN1440q LLC · Maybee, MIS/N 15072740N1441QSale Reported · Franklin, INSale reportedBuilt 1971 · S/N 15072741N1442QDelaware Aviation LLC · Sidney, NYBuilt 1971 · S/N 15072742N1444QPelco Aviation Inc · Hampton Bays, NYBuilt 1971 · S/N 15072744N1446QBeek Dudley Ernest · Miami, FLS/N 15072746N1448QWjs Aircraft LLC · New Smyrna Beach, FLBuilt 1971 · S/N 15072748N1449QAero Maintenance Inc · Vancouver, WABuilt 1971 · S/N 15072749N144CRFrantz David L · Manchester, TNBuilt 1973 · S/N 15075438N1455QJackson Scott G · Layton, UTS/N 15072755N1461QMarquez Christopher D · Fleming Island, FLBuilt 1971 · S/N 15072761N146JHGodinez Mauricio U · San Diego, CAS/N 15066426N1471QRader Gregory · Baldwin City, KSBuilt 1971 · S/N 15072771N1476QHarley Dennis E Sr · Cole Camp, MOBuilt 1971 · S/N 15072776N1483QAttax LLC · Missoula, MTBuilt 1971 · S/N 15072783N1484QIntegrated Structural Services Inc · Ringgold, GABuilt 1971 · S/N 15072784N1485QMartin Aviation LLC · Bargersville, INS/N 15072785N1488QTorney Sean M · Angier, NCBuilt 1971 · S/N 15072788N148ELFrazier James M III · Saint Marys, KSBuilt 1975 · S/N 15077412N1492QDavison James D · Richmond, MAS/N 15072792N1494QSauter Allen · Bismarck, NDBuilt 1971 · S/N 15072794N1496QDonat Brandon L · Glendale, AZBuilt 1971 · S/N 15072796N14AUBazzo Richard J · Broadview Heights, OHBuilt 1967 · S/N 15064814N14CWThornwall Gregory C · Boonsboro, MDBuilt 1969 · S/N 15070656
Back to AD 2009-10-09 R2