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.

N3727JAerowood Aviation LLC · Monroe, NCBuilt 1966 · S/N 15065027N3728JSpo Aviation LLC · Eufaula, OKBuilt 1966 · S/N 15065028N372DRees Ryan G · Loa, UTS/N 15070466N3733VToccoa Aviation · Toccoa, GABuilt 1975 · S/N 15076605N3734JTrue Course LLC · Honolulu, HIBuilt 1966 · S/N 15065034N3734VBurrell Dennis E · Parma, IDS/N 15076606N3735JPetersen Kenton D · Jefferson, SDBuilt 1966 · S/N 15065035N3737VClarke Adrian N · Aledo, TXBuilt 1975 · S/N 15076607N373KVCrystalinas Johnathan · Rancho Cordova, CABuilt 1966 · S/N 15064401N3740JHersom Jeffrey T · Helena, MTBuilt 1966 · S/N 15065040N3741JSharp Ruth · Clarksville, TNBuilt 1966 · S/N 15065041N3742JLow Cost Flying LLC · Chandler, AZBuilt 1966 · S/N 15065042N3746JCrandall Lloyd G · Lake City, MIBuilt 1966 · S/N 15065046N3747JRegistration Pending · Bay Harbor Islands, FLRegistration pendingS/N 15065047N3749JLove Duane Anthony · San Rafael, CAFirst renewal noticeBuilt 1966 · S/N 15065049N3750JEagle East Aviation Inc · North Andover, MABuilt 1966 · S/N 15065050N3750VNeal Latimer B IV · Fayetteville, GABuilt 1975 · S/N 15076610N3752JLudwig Daniel C · New Rockford, NDBuilt 1966 · S/N 15065052N3753JWallin Joshua M · Moreno Valley, CAS/N 15065053N3756JLong Donald R · Seneca, SCBuilt 1966 · S/N 15065056N3760JWeeks Ryan A · Sneads Ferry, NCBuilt 1966 · S/N 15065060N3765JSatanta Flying Service Inc · Satanta, KSS/N 15065065N3766VHaile Kempton Crosby · Warrenton, VABuilt 1975 · S/N 15076612N3767JHalbur Wesley D · Heron Lake, MNBuilt 1966 · S/N 15065067N3768JWheeler Kevin M Trustee · Comstock Park, MIBuilt 1966 · S/N 15065068N3768VHaynes Robert K · Pilot Point, TXBuilt 1975 · S/N 15076614N3769JRatner Robert D · Swan Lake, NYBuilt 1966 · S/N 15065069N3769VSky High Investments LLC · Greenwood, INS/N 15076615N3770JAzad Raja M · Hawthorne, CABuilt 1966 · S/N 15065070N3771JKozel Thomas · Pottstown, PABuilt 1966 · S/N 15065071N3773JBertrand Aviation LLC · Brookville, KSBuilt 1966 · S/N 15065073N3776VCoach Masters Inc · Kearney, NES/N 15076619N3777VOld School Aviation · Ottsville, PABuilt 1975 · S/N 15076620N3778VSmith Harold J · Poughkeepsie, NYBuilt 1975 · S/N 15076621N3781JSantonocito John A · Bradenton, FLBuilt 1966 · S/N 15065081N3784JMilbourn Edward M · Greenfield, INBuilt 1966 · S/N 15065084N378VUDennis Ryan B · Delphi, INS/N 15063713N3793JMccoy Michael B · Colbert, WABuilt 1966 · S/N 15065093N3799JGiger Michael R · Slater, MOBuilt 1966 · S/N 15065099N379MBRoeper Gary L · Linden, MIBuilt 1975 · S/N 15077109N379PFRegistered aircraftS/N 15069689N37CFAlmond Kevin · Waxahachie, TXBuilt 1972 · S/N 15073807N37MMLeitch Mark W · Naples, FLBuilt 1966 · S/N 15062913N37PPParsons Paul M · Aurora, COBuilt 1968 · S/N 15069944N37ZQMagnum Aviation LLC · Goff, KSBuilt 1978 · S/N 15282684N3801JSchomberg Coby D · Washington, MOBuilt 1966 · S/N 15065101N3804JBranagh Charles J · Clay, NYBuilt 1966 · S/N 15065104N3811JWright Wayne M DBA · Chestertown, MDBuilt 1966 · S/N 15065111N3811VFlying Asian Aviation Inc · Richmond, CANon-citizen corporation, flight hours not reportedBuilt 1975 · S/N 15076630N3813JWinnie Daniel R · Seattle, WABuilt 1966 · S/N 15065113
Back to AD 2009-10-09 R2