OpenAirDocs.org
AD 2009-10-09 R2

Registered aircraft · 8,565

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.

N704DTWasson Tom L · Lakeport, CAS/N 15078535N704DUWinstead Walley K · Leavenworth, KSBuilt 1976 · S/N 15078536N704DXBaskov Andrei · Irvine, CABuilt 1976 · S/N 15078539N704DYSommers Delwyn L · Ochlocknee, GABuilt 1976 · S/N 15078540N704DZWest Michigan Flying Club Inc · Norton Shores, MIBuilt 1976 · S/N 15078541N704EGMartinez Stephen D · Belton, MOBuilt 1976 · S/N 15078548N704ELLancaster Aero LLC · Smoketown, PABuilt 1976 · S/N 15078552N704EMFee Eaman · Pembroke, MABuilt 1976 · S/N 15078553N704ERBeckwith James N · Goldsboro, NCS/N 15078557N704EVJones Janet J · Burlington, VTBuilt 1976 · S/N 15078561N704EXMouw Jacob W H · Palmer, AKBuilt 1976 · S/N 15078563N704EZBellas Business LLC · Kalispell, MTBuilt 1976 · S/N 15078565N704FEOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeBuilt 1976 · S/N 15078570N704FKTb Maintenance And Cleaning LLC · Deltona, FLBuilt 1976 · S/N 15078575N704FNNorman Charles E DBA · Zanesville, OHBuilt 1976 · S/N 15078577N704FPKopache Gregory · Boulder, COBuilt 1976 · S/N 15078578N704FQLapinel Marc P · Long Beach, NYS/N 15078579N704FWHorton Jimmie D · Orlando, FLS/N 15078585N704FXKlingenberg Alice Ruth · Derby, KSBuilt 1976 · S/N 15078586N704FYWassair Aviation LLC · Elkhorn, WIS/N 15078587N704FZDanto Peter J · Concord, CABuilt 1976 · S/N 15078588N704GGillis Ryan T · Kenai, AKS/N 15078638N704GCSteffen Craig · Harrogate, TNBuilt 1976 · S/N 15078591N704GDMacmorris Clifford Jr · Naples, FLBuilt 1976 · S/N 15078592N704GEPester Jerome · Hingham, MTBuilt 1976 · S/N 15078593N704GFDresti Mauro · Pomona, CABuilt 1976 · S/N 15078594N704GGGorin Gustavo A · Statesboro, GABuilt 1976 · S/N 15078595N704GKMcmullen Julie A · Skwentna, AKBuilt 1976 · S/N 15078598N704GRMellor James F · Spanish Fork, UTFirst renewal noticeBuilt 1976 · S/N 15078604N704GXHunt Greg · Rolling Prairie, INBuilt 1976 · S/N 15078610N704HBOtero Alberto A · Fort Pierce, FLBuilt 1976 · S/N 15078614N704HCBrown William C · Columbia, CABuilt 1976 · S/N 15078615N704HDCleary John P · Worcester, MABuilt 1976 · S/N 15078616N704HEFour Sisters Aviation LLC · Fayetteville, GABuilt 1976 · S/N 15078617N704HFNo Name Aviation LLC · Wilmington, DES/N 15078618N704HGAvery Ricky E · Redfield, SDBuilt 1976 · S/N 15078619N704HKChilstrom John S · Austin, TXBuilt 1976 · S/N 15078622N704HRLitcof Brian P · Moultonborough, NHBuilt 1976 · S/N 15078628N704HYStatter Daniel E · Chicago, ILBuilt 1976 · S/N 15078635N704JCAskenasy George R · Cleburne, TXBuilt 1976 · S/N 15078639N704JFHammer Joseph W Jr · Shannon, ILBuilt 1976 · S/N 15078642N704JHPhelps Clay DBA · Santa Paula, CABuilt 1976 · S/N 15078644N704JKWardle Lynn A · Rogue River, ORBuilt 1976 · S/N 15078646N704JLSprecher Susan E · Locust Grove, GABuilt 1976 · S/N 15078647N704JQRusso Robert J · Hope Valley, RIS/N 15078651N704JRAirgo Inc · Centralia, ILBuilt 1976 · S/N 15078652N704JSCassels William · Phoenix, AZBuilt 1976 · S/N 15078653N704JVVan Zyl Larry D Trustee · Sherwood Forest, CABuilt 1976 · S/N 15078656N704JXSchwettmann Dennis E · Nampa, IDBuilt 1976 · S/N 15078658N704KAMartin Noah I · Brookeville, MDBuilt 1976 · S/N 15078661
Back to AD 2009-10-09 R2