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.

N8440UNicholls Donald B · East Amherst, NYBuilt 1976 · S/N 15077936N8441JAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1967 · S/N 15066341N8442GFoster Dustin · Dublin, VAS/N 15062542N8443GVon Wald Enterprises LLC · Glendale, AZBuilt 1965 · S/N 15062543N8443JThunderbolt Resourcing LLC · Warrensburg, MOBuilt 1967 · S/N 15066343N8446JBent James L Jr DBA · Palatine Bridge, NYS/N 15066346N8448GMidwest Aviation Services LLC · Kendallville, INBuilt 1965 · S/N 15062548N8448MMohamed Jaleel · Dallas, TXBuilt 1969 · S/N A1500148N8449JSchaff James F · Gakona, AKBuilt 1967 · S/N 15066349N8449MCopper River Airmotive LLC · Copper Center, AKBuilt 1969 · S/N A1500149N8450MChoquette Marc J · Juneau, AKBuilt 1969 · S/N A1500150N8451MDelalat Shariar · San Diego, CABuilt 1970 · S/N A1500151N8452MHigh Flight LLC · Mount Pleasant, SCS/N A1500152N8453GBelue Gaythan D · Rogersville, ALBuilt 1965 · S/N 15062553N8455JBentz Jack E · Huntington, WVBuilt 1967 · S/N 15066355N8456GAerial Perspective Inc · Fullerton, CABuilt 1965 · S/N 15062556N8456JHam Russell W · Dike, TXBuilt 1967 · S/N 15066356N8458JGp Aviation Leasing LLC · Hughson, CAS/N 15066358N8458MChapman Brian P · Tulsa, OKBuilt 1970 · S/N A1500158N8460JHouston Juan D · Parkton, NCBuilt 1967 · S/N 15066360N8461GColbert Donald H · Tonasket, WABuilt 1966 · S/N 15062561N8461JBailey Roger · Mccool, NEBuilt 1967 · S/N 15066361N8464GWhite Sands Soaring Association Inc · Alamogordo, NMBuilt 1965 · S/N 15062564N8464MBarrineau Charles A · Palatka, FLBuilt 1970 · S/N A1500164N8465GBeltz Darren S · Mattawan, MIBuilt 1965 · S/N 15062565N8471MSmith Trevor A · Justin, TXBuilt 1970 · S/N A1500171N8472GDirk Chantz M · Rapid City, SDBuilt 1966 · S/N 15062572N8472JEck Alan C · Henderson, MDBuilt 1967 · S/N 15066372N8473GDyck David · Sumner, TXBuilt 1968 · S/N 15067474N8473JKnighton Dennis · Headland, ALS/N 15066373N8473MSpitzer Terry E · Kalona, IABuilt 1970 · S/N A1500173N8474JHoward Linda Faye · Pink Hill, NCS/N 15066374N8474MBrowning Lonnie O IV · Allendale, SCBuilt 1970 · S/N A1500174N8475JRemar Chuck · Poplar Grove, ILBuilt 1967 · S/N 15066375N8477JLake Benjamin Joseph · Garland, TXS/N 15066377N8478GTaylor Scott G · Draper, UTS/N 15062578N8478JKnapp Caleb J · Aledo, TXS/N 15066378N8479GRoscoe J Chandler · Midlothian, TXS/N 15062579N8480GMatthews Scott R · Baker City, ORS/N 15062580N8480JLeach Flight Services LLC · Aledo, TXBuilt 1967 · S/N 15066380N8483JHouston County Flying Club · Crockett, TXS/N 15066383N8484JBivens Jason D · Duncan, OKBuilt 1967 · S/N 15066384N8485GWhipple James M · Wadsworth, OHS/N 15062585N8486JLysogorski Edward P · Bridgeport, MIBuilt 1967 · S/N 15066386N8487JSeigler William C · Weatherford, TXBuilt 1967 · S/N 15066387N8490GDodot Daniel A · Westminster, COS/N 15062590N8490JB&K Holdings LLC · Birmingham, ALBuilt 1967 · S/N 15066390N8490MMathison John · Vancouver, WAS/N A15000190N8491GMil2atp Inc · Pikeville, NCBuilt 1966 · S/N 15062591N8491MHollenbaugh Gerald K · Glenwood Springs, COBuilt 1970 · S/N A1500191
Back to AD 2009-10-09 R2