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.

N3364JSlawski Michael E · Tucson, AZBuilt 1967 · S/N 15066064N3370VHolladay Aviation LLC · Jacksonville, FLBuilt 1974 · S/N 15076477N3372VSimmons Robert J · Rising Fawn, GABuilt 1974 · S/N 15076478N3376VHill Craig · Memphis, TNBuilt 1974 · S/N 15076481N3377JGriffith Scott · Hewitt, TXBuilt 1967 · S/N 15066077N3377VGardner Terrence L · Pittsboro, NCS/N 15076482N337XCHoover Rodney A · Wasilla, AKBuilt 1966 · S/N 15062891N3380JEsparza Edel · Chula Vista, CABuilt 1967 · S/N 15066080N3384VNewby Aviation LLC · Pingree Grove, ILS/N 15076484N3385JGonzales Mark S · Dothan, ALS/N 15066085N3386VFrg III Inc DBA · Lincoln Park, NJBuilt 1974 · S/N 15076486N3387JMy Piper Pacer LLC · Everett, WAS/N 15066087N3390JVandyke Dennis C · Rose Hill, VABuilt 1967 · S/N 15066090N3395JFly N Style · Parkland, FLBuilt 1967 · S/N 15066095N3396VHarvey Christopher J · Port Leyden, NYBuilt 1974 · S/N 15076488N3397JZwerko Sherri · South Plainfield, NJBuilt 1967 · S/N 15066097N33DPB&C Cejka Real Estate LLC · Sioux City, IABuilt 1967 · S/N 15066465N33GSFish N Fly LLC · Hobe Sound, FLS/N 15281292N33LJUniversal Aviators Academy Inc · El Monte, CABuilt 1978 · S/N 15282023N3400VLanier Gary L · Bloomington, ILBuilt 1974 · S/N 15076490N3405JRichmond Consulting LLC · Blanding, UTS/N 15066105N3406JScholle Joseph E · Mustang, OKBuilt 1967 · S/N 15066106N3409JMountain Home Oasis LLC · Albuquerque, NMBuilt 1967 · S/N 15066109N340SXHeavy Metal Air LLC · Farmingdale, NYBuilt 1981 · S/N 15285141N3410JNewsom Rickey D · Springfield, ARS/N 15066110N3413VNiles Air LLC · Concord, NCBuilt 1974 · S/N 15076493N3421JOakley Lance · Haslet, TXS/N 15066121N3421VNebbia Valter Della · Archer City, TXBuilt 1974 · S/N 15076498N3422JRoberts Stephen L · Belmont, MIBuilt 1967 · S/N 15066122N3424JBaird Gary H · Bracey, VABuilt 1967 · S/N 15066124N3424VDriscoll Christopher · Beaufort, SCBuilt 1974 · S/N 15076499N3425JSanders Robert · Harlingen, TXBuilt 1967 · S/N 15066125N3428VNordquist Alexandra · Wasilla, AKS/N 15076500N3429JBrown Jason · Wonder Lake, ILBuilt 1967 · S/N 15066129N3429VSowieja Gary D · Inver Grove, MNBuilt 1974 · S/N 15076501N342BCMouriz Javier · Leesburg, FLBuilt 1968 · S/N 15068493N3433JJason Webster · Orlando, FLBuilt 1967 · S/N 15066133N3435JRegistration Pending · Florence, AZRegistration pendingBuilt 1967 · S/N 15066135N3440JNoguess Michele R · Deming, NMBuilt 1967 · S/N 15066140N3453JBmsf Co LLC · Copalis Beach, WAS/N 15066153N3453VJones Donald T Jr · Barrigada, GUBuilt 1974 · S/N 15076506N3454JIslanders Flying Club · Charleston, WVBuilt 1967 · S/N 15066154N3454VZimmer Bernard A · Waxhaw, NCBuilt 1974 · S/N 15076507N3458JHoughton Raymond A · Fort Bragg, CABuilt 1967 · S/N 15066158N345EEKielich Darryl C · Elk Grove, CABuilt 1967 · S/N 15066281N3460VDegeorge Richard L · Cape Coral, FLBuilt 1974 · S/N 15076508N3461JSmith Stephen T · Hale, MIBuilt 1967 · S/N 15066161N3466JSale Reported · Fruita, COSale reportedBuilt 1967 · S/N 15066166N3467JKlempel Reuel D · Eltopia, WABuilt 1967 · S/N 15066167N3468JC&C Aero LLC · Billings, MTS/N 15066168
Back to AD 2009-10-09 R2