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.

N11616Registration Pending · San Bernardino, CARegistration pendingBuilt 1974 · S/N 15075570N11619Lewis Billy D · Cleveland, GABuilt 1974 · S/N 15075573N11621Hopkins Josh · Corpus Christi, TXS/N 15075575N11626Frantz Ellen C · Abbeville, GABuilt 1974 · S/N 15075580N11628Monon Bell Aviation LLC · Brownsburg, INBuilt 1974 · S/N 15075582N11634Ryan Leo A · Jamestown, NDBuilt 1974 · S/N 15075587N11639Tubb Terry L · Centerton, ARBuilt 1974 · S/N 15075591N11731Dupree Wesley W · Molena, GABuilt 1974 · S/N 15075597N11732Lewis Nathan Alan · Crestline, CABuilt 1974 · S/N 15075598N11738Tat Networks And Aviation LLC · Bend, ORS/N 15075602N11746Flying Panthers Flight School Inc · Citrus Heights, CABuilt 1974 · S/N 15075609N11748Kilber Ronald P · Salome, AZBuilt 1974 · S/N 15075610N11749Adams Chad R · Joplin, MOBuilt 1974 · S/N 15075611N11766Haig Dennis A · Andover, KSBuilt 1974 · S/N 15075621N11772Pope John P · Chehalis, WABuilt 1974 · S/N 15075624N11775Witzel Daryle L · Porterville, CABuilt 1974 · S/N 15075625N11779Talbert Robert David · Granbury, TXBuilt 1974 · S/N 15075627N11786Barbee Donald L · Columbus, OHBuilt 1974 · S/N 15075631N117SSSoutheastern Okalhoma State University · Durant, OKBuilt 1976 · S/N 15079025N117TSRegistration Pending · Portland, MERegistration pendingBuilt 1968 · S/N 15069427N117WJMyles Winnfort · Madison, MSBuilt 1973 · S/N 15075427N11815Herman Nicholas A · Lyndhurst, VAS/N 15075645N11816Vanderwal Carter W · Pollock, SDBuilt 1974 · S/N 15075646N11821Rasberry Freddie L Jr · Roby, TXBuilt 1974 · S/N 15075649N11824Aircraft Partner Holdings Inc Trustee · BerlinBuilt 1974 · S/N 15075652N11826Burrows-Mcelwain James Bryan · Martinsburg, WVBuilt 1974 · S/N 15075654N11839Magee Ray C · Shelburne, VTBuilt 1974 · S/N 15075665N11840Gard Aviation LLC · Wooster, OHBuilt 1974 · S/N 15075666N11841Amor Aviation LLC · Chapin, SCBuilt 1974 · S/N 15075667N11846Stage Crew LLC · Davenport, FLBuilt 1974 · S/N 15075672N11849Ltf LLC · Soldotna, AKBuilt 1974 · S/N 15075675N11873French Justin T · Broken Bow, NES/N 15075677N11876Evans Ashley Eugene · Elizabeth, COBuilt 1974 · S/N 15075680N11880Carbaugh Nicholas C · Seattle, WABuilt 1974 · S/N 15075683N11883Bedell Samuel G · Fairbanks, AKBuilt 1974 · S/N 15075685N11886Thompson Strawberry Farm Inc · Bristol, WIBuilt 1974 · S/N 15075688N11891Livesay Gregory K · Mc Kinney, TXBuilt 1974 · S/N 15075691N11892Virani Sohail · Euless, TXBuilt 1974 · S/N 15075692N11893Cowand II Jerry H · Merry Hill, NCS/N 15075693N11899Mccrigler Luke N · Fortuna, CABuilt 1974 · S/N 15075696N118SSSoutheastern Oklahoma State University · Durant, OKBuilt 1975 · S/N 15077132N11906Rodriguez Jose · Los Angeles, CABuilt 1974 · S/N 15075701N11909Weaver Craig A · Pickerington, OHBuilt 1974 · S/N 15075703N11910Destefano Dennis C · New Port Richey, FLS/N 15075704N11913Sharkey Peter T · Providence, RIBuilt 1974 · S/N 15075706N11927Omlid Robert · Watford City, NDBuilt 1974 · S/N 15075712N11935Legacy Pilot Training LLC · Annandale, MNBuilt 1974 · S/N 15075713N11936West Yayoi M · Sonoma, CABuilt 1974 · S/N 15075714N11938Johnson William L · Middleburg, VABuilt 1974 · S/N 15075716N11940Elkeberry Morgan T · Sycamore, OHBuilt 1974 · S/N 15075718
Back to AD 2009-10-09 R2