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.

N2728JWahlberg · Pearland, TXBuilt 1974 · S/N A1500573N2729SDates Lauren C · Red Creek, NYBuilt 1967 · S/N 15066629N2731JPatry Aeronautical Institute · Kalispell, MTBuilt 1974 · S/N A1500574N2734JHelbig Frederick E · Oakland, MDBuilt 1974 · S/N A1500576N2737SBlock Oliver L · Nashville, TNBuilt 1967 · S/N 15066637N2739JCiulla Santo · Odessa, FLBuilt 1974 · S/N A1500578N2745JRegistered aircraftBuilt 1974 · S/N A1500581N2745SGobble Larry L · Williamson, GABuilt 1967 · S/N 15066645N2746JGelatt Joseph · Wasilla, AKS/N A1500582N2746SBryant Stan M · Derby, KSBuilt 1967 · S/N 15066646N2750SMcmichael Olen G · Antwerp, OHBuilt 1967 · S/N 15066650N2752SWhite Orion H · Moses Lake, WAS/N 15066652N2753SSlownlow LLC · Kalispell, MTBuilt 1967 · S/N 15066653N2754SGaddis Rebekah J · Valley City, OHBuilt 1967 · S/N 15066654N2758JSoutiere Theresa Yvette · Juneau, AKBuilt 1975 · S/N A1500588N2758SBogner Edward R · Santa Cruz, CABuilt 1967 · S/N 15066658N2759JNg Byron · Foster City, CAS/N A1500589N2760SBond Doyle G · Walker, LABuilt 1967 · S/N 15066660N2761JAldrich Curtiss R · Big Oak Flat, CAS/N A1500590N2763SMoore Park · Byron, GABuilt 1967 · S/N 15066663N2764SBivens Jason D · Duncan, OKBuilt 1967 · S/N 15066664N2766JBedford Dennis · Auke Bay, AKBuilt 1975 · S/N A1500591N2766SJohnston Beryle Lee · Franklin, PABuilt 1967 · S/N 15066666N2768SSibley Michael Neal · Kenai, AKBuilt 1971 · S/N 15066668N2770SBirk Ronald G · Wellington, NVBuilt 1967 · S/N 15066670N2773JN2773j LLC · Titusville, FLBuilt 1975 · S/N A1500596N2774SPeterson Dennis · Cambridge, MNBuilt 1967 · S/N 15066674N2775SRichardson Arthur · Herald, CAS/N 15066675N2778SStamper Brian L · Tucson, AZBuilt 1967 · S/N 15066678N277KLCoombs Johnnie · Blue Mountain, MSBuilt 1966 · S/N 15064869N277RTGonzalez Edwin A · Scott Afb, ILBuilt 1968 · S/N 15070021N2780SNapolitano Frank D · Howell, MIBuilt 1967 · S/N 15066680N2781SGadberry Garth · Heath, TXBuilt 1967 · S/N 15066681N2784SThomas Michael R · Marshall, MOS/N 15066684N2789JStephens Mark E Trustee · Morgan Hill, CABuilt 1975 · S/N A1500601N2790JLock Robert Allen · Grand Haven, MIBuilt 1975 · S/N A1500602N2791JPuget Sound Flyers Inc · Everett, WABuilt 1975 · S/N A1500603N2798JCenter Of Gravity Flying Club LLC · Monterey, CABuilt 1975 · S/N A1500607N27TDMenor Michael D · Menominee, MIBuilt 1966 · S/N 15065577N2800SSimpson Gavin J · Medford, ORBuilt 1967 · S/N 15066700N2801SLavere Paul · Adams, NYBuilt 1967 · S/N 15066701N2802SBurt Charley R · Anchorage, AKBuilt 1967 · S/N 15066702N2804SAlmy David W · Riverside, CABuilt 1967 · S/N 15066704N2810SWaco West Inc · Dover, DEBuilt 1967 · S/N 15066710N2810VDipasquale Glenn D · Gloversville, NYBuilt 1974 · S/N 15076288N2814VCentral Ohio Soaring Association · Marion, OHBuilt 1974 · S/N 15076290N2815TNorwest Ventures LLC · Sagle, IDBuilt 1978 · S/N 15282250N2819SBeale Frank B II · Bowling Green, VABuilt 1967 · S/N 15066719N2821SHancock Jeffrey A · Jacksonville, TXS/N 15066721N2823SSpark Aero LLC · Christiansburg, VABuilt 1965 · S/N 15062301
Back to AD 2009-10-09 R2