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.

N61041Pattison Aero Inc · Upland, CABuilt 1969 · S/N 15070758N6104QSorby Jerry N · Fort Ransom, NDBuilt 1981 · S/N 15285129N61051Crispin Michael J · Broadalbin, NYBuilt 1969 · S/N 15070765N61052Secker-Walker Hugh E · Newburyport, MAS/N 15070766N61055Booher Tabitha O · Livingston, TNBuilt 1969 · S/N 15070768N61057Provenzano Jeremy E · Aurora, COBuilt 1969 · S/N 15070770N6105QAero Quest LLC DBA · Olive Branch, MSBuilt 1981 · S/N 15285130N61061Townsend John J · Valliant, OKBuilt 1969 · S/N 15070773N61062Bate David F · Vanceburg, KYBuilt 1969 · S/N 15070774N61064N61064 LLC · Forest Park, ILBuilt 1969 · S/N 15070775N61067Connolly Luile A · Blaine, MNBuilt 1969 · S/N 15070777N6106QSunrise Aviation Inc · Ormond Beach, FLBuilt 1981 · S/N 15285131N61075Evan R Charles · Riverside, CAS/N 15070780N61077Ray Albert B · Prosser, WAS/N 15070782N61078Registered aircraftBuilt 1969 · S/N 15070783N6107GRhea Koy A · Annona, TXBuilt 1969 · S/N 15071607N61081Beattie Mark A · Anaheim, CABuilt 1969 · S/N 15070784N6108GPetrov Konstantin P · Hallandale, FLBuilt 1969 · S/N 15071608N61091O'Flynn Brian · Mimbres, NMBuilt 1969 · S/N 15070794N61094Harper Kevin J · Valley Center, KSBuilt 1969 · S/N 15070795N61097Giles David Victor · Gilbert, AZBuilt 1969 · S/N 15070798N6109KRiegel Frederick E · Houston, OHBuilt 1975 · S/N 15077530N61104Backwoods Air LLC · Caro, MIBuilt 1969 · S/N 15070803N61108Umrysz Jeffrey E · Mystic, CTBuilt 1969 · S/N 15070807N6110GHigh Exposure Inc · Wilmington, DEBuilt 1969 · S/N 15071610N61110Veit Brett Allen · Willis, TXS/N 15070809N61112Ralph Joshua C · Wichita, KSS/N 15070811N61114Thomas O Bailey · Sutton, NDBuilt 1969 · S/N 15070813N6111QAces High Aviation LLC · Long Beach, CABuilt 1981 · S/N 15285136N61120Jstream Lc · Sheridan, WYBuilt 1969 · S/N 15070814N61123Starnes Robert D · Lavonia, GABuilt 1969 · S/N 15070816N61126Roth Jason G · Seattle, WABuilt 1969 · S/N 15070819N61127Mcgill Phil · Huntsville, ALBuilt 1969 · S/N 15070820N61129Jones Flying Service LLC · Pulaski, TNS/N 15070822N6112KNordby Tyler D · Herman, MNBuilt 1975 · S/N 15077532N61130Registration Pending · Wilmington, DERegistration pendingBuilt 1969 · S/N 15070823N61131Anderson Jerry · Vacaville, CABuilt 1969 · S/N 15070824N61132Whithaus Douglas A · Panama City, FLBuilt 1969 · S/N 15070825N6113GPratt Aviation Services Inc · Anchorage, AKBuilt 1969 · S/N 15071613N61140Johnson Darryl W · Fowler, COBuilt 1969 · S/N 15070831N61141Holmes Meg C · Winterport, MEBuilt 1969 · S/N 15070832N61143Hedlund Wesley H · Newburgh, MEBuilt 1969 · S/N 15070834N61144Schenk Flight Service LLC · Ainsworth, NEFirst renewal noticeBuilt 1969 · S/N 15070835N61145N61145 LLC · Seattle, WAS/N 15070836N61152Cunneen Regan M · Vista, CABuilt 1969 · S/N 15070841N61156Williams Tommy J · San Angelo, TXBuilt 1969 · S/N 15070845N61157Bravo Holdings LLC · St Francis, WIBuilt 1969 · S/N 15070846N61159Stenger D James Trustee · Sonora, CABuilt 1969 · S/N 15070847N61163Miller William M · Enterprise, KSBuilt 1969 · S/N 15070851N61166Om Air LLC · Saint Louis, MOS/N 15070852
Back to AD 2009-10-09 R2