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.

N8350JSustarich Stephen M · Ketchikan, AKS/N 15066250N8351JRkd Aviation Services Inc · Dallas, TXBuilt 1967 · S/N 15066251N8351MWheaton Eric J · Gig Harbor, WAS/N A1500051N8352JByrds Wholesale Inc · Clayton, NCS/N 15066252N8352MOak Ridge Flyers Inc · Oak Ridge, TNBuilt 1969 · S/N A1500052N8353GHove Jeffrey P · Saint Paul, MNBuilt 1965 · S/N 15062453N8355GGrant Jimmy L · Ada, OKBuilt 1965 · S/N 15062455N8355JPadilla Hector F · Mountain View, CABuilt 1967 · S/N 15066255N8355MRcs Services LLC · California, MDFirst renewal noticeBuilt 1969 · S/N A1500055N8355UWilhelm Joshua Robert · Lake Havasu City, AZBuilt 1976 · S/N 15077925N8356MSporie George F · Marinette, WIBuilt 1969 · S/N A1500056N8357KBaldasaro Bonnie B · Clifton Park, NYS/N 15070575N8358JMorrow John E · Clarendon, TXBuilt 1967 · S/N 15066258N8359JManchester Eric S · Milton, VTBuilt 1967 · S/N 15066259N8360MOld Goat Aviation LLC · Naples, FLBuilt 1969 · S/N A1500060N8360UHead Joseph · Fairbanks, AKS/N 15077927N8361JCoughlin Kevin P · Ridge, NYBuilt 1967 · S/N 15066261N8364MComchoc Paul R · Bellevue, WABuilt 1969 · S/N A15000064N8365GMendez Carlos L · Somerset, NJBuilt 1965 · S/N 15062465N8366GRovers Adrian J · Chazy, NYBuilt 1965 · S/N 15062466N8366JRobertson R Topp · Decatur, TXBuilt 1967 · S/N 15066266N8366MMccauley Aviation Inc · Springfield, TNBuilt 1969 · S/N A15000066N8367GRangesh Abinand · Newton, MABuilt 1965 · S/N 15062467N8367MConner Jacob P · Kaplan, LABuilt 1969 · S/N A1500067N8368GClark Jeffrey S · Knoxville, TNBuilt 1965 · S/N 15062468N8368JVickers Lindsay · Fuquay Varina, NCBuilt 1967 · S/N 15066268N8369JDtm Enterprises Inc · Bronson, MIBuilt 1967 · S/N 15066269N8370GCarter Edward D · Ethel, MOBuilt 1965 · S/N 15062470N8370JBrown David A · Lumberton, TXBuilt 1967 · S/N 15066270N8370MLandry Paul G · Fallon, NVS/N A1500070N8371MNosewheels Navy LLC · Rochester Hills, MIBuilt 1969 · S/N A1500071N8372JPaquette Michael J · Greene, NYBuilt 1967 · S/N 15066272N8373GColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1965 · S/N 15062473N8373MBond Hiram E · Pls Vrds Est, CABuilt 1969 · S/N A1500073N8375JAtlanta Aircraft Consultants LLC · Rex, GABuilt 1967 · S/N 15066275N8376MPhillips Lester L · Pahrump, NVS/N A1500076N8377MBoyd Edward Lee · Apison, TNBuilt 1969 · S/N A1500077N8378MKuklo Robert M · Livermore, CABuilt 1969 · S/N A1500078N8378UMartin Garland L · Zephyrhills, FLBuilt 1976 · S/N 15077929N8379JLin Air LLC · Oviedo, FLBuilt 1967 · S/N 15066279N8382GArneson Kenneth W · Beaverton, ORS/N 15062482N8382JHouseknecht Thomas · State College, PABuilt 1967 · S/N 15066282N8383MKessler Aviation LLC · Lansing, WVBuilt 1969 · S/N A1500083N8384GWoodall Steve W · Penngrove, CABuilt 1965 · S/N 15062484N8384JKondol Andrlej J · Maspeth, NYBuilt 1967 · S/N 15066284N8384M1st Clev-Mar LLC · Gainesville, TXBuilt 1969 · S/N A1500084N8385JJones Stanley E · Vallejo, CABuilt 1967 · S/N 15066285N8386GIndy Hot Air LLC · Westfield, INBuilt 1965 · S/N 15062486N8386JMyers Raymond R · Deer Park, WABuilt 1967 · S/N 15066286N8387GAir Land And Sea Adventures LLC · West Palm Beach, FLBuilt 1965 · S/N 15062487
Back to AD 2009-10-09 R2