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.

N6295GRegistration Pending · Eliot, MERegistration pendingBuilt 1970 · S/N 15071795N6296KMclean Lachlan · North Creek, NYBuilt 1975 · S/N 15077629N6297RBejna Robert C · Addison, ILBuilt 1965 · S/N 15061597N62983Studer Rodney J · Shelby, MIS/N 15063618N6298MLapham John R · Palm Beach Gardens, FLBuilt 1980 · S/N 15284660N6299KMarco Aviation Club Corp · Naples, FLBuilt 1975 · S/N 15077630N6299RNorwood Dan L · Chippewa Falls, WIBuilt 1965 · S/N 15061599N6299SSena Gregori C · Buckeye, AZBuilt 1967 · S/N 15067099N62CGJain Ashish K · Hamilton, GABuilt 1973 · S/N 15075134N63000Jet Boy LLC · Henderson, NVBuilt 1975 · S/N 15077036N63001Rbv Aviation And Cattle LLC · Kalispell, MTS/N 15077037N63002Nolt Shannon E · East Earl, PAS/N 15077038N63003Newell Rory H · Warner Springs, CAS/N 15077039N63006Registration Pending · Snohomish, WARegistration pendingBuilt 1975 · S/N 15077042N63008Wheaton Eric J · Gig Harbor, WAS/N 15077044N6300KCash Richard W · Bossier City, LABuilt 1975 · S/N 15077631N6300QPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1981 · S/N 15285225N6301LHarding Benjamin H Jr · Yadkinville, NCBuilt 1980 · S/N 15284384N6301SAbercrombie Michael J · Eureka, CABuilt 1967 · S/N 15067101N63033Baumer Luke R · Pittsboro, INS/N 15077051N63036Registered aircraftS/N 15077052N63040Bullington Michael D · Spring Hill, TNBuilt 1975 · S/N 15077056N63042Ting Chih-Wei · Tracy, CABuilt 1975 · S/N 15077058N63046Lindholm Michael D · Anchorage, AKS/N 15077060N63047Ggf Inc · Jacksonville, ARS/N 15077061N6304MMls Aviation LLC · Yorba Linda, CABuilt 1980 · S/N 15284663N6304SCowey Kevin M · Pittsburgh, PAS/N 15067104N63051Moss Ronald J · Hamer, IDBuilt 1975 · S/N 15077065N63053Claeys John T · Blue Grass, IABuilt 1975 · S/N 15077066N63057Guerra Enmanuel M · Weirsdale, FLBuilt 1975 · S/N 15077070N6305SPrivette Hugh T Trustee · Colorado Springs, COS/N 15067105N63062Cade Richard G · Lopez Island, WABuilt 1975 · S/N 15077074N63066Rench Eugene G · Owosso, MIBuilt 1975 · S/N 15077075N6306GMartin Robert · Sylvester, GABuilt 1970 · S/N 15071806N63074Charlton Jeremiah · Rockford, ILBuilt 1975 · S/N 15077082N63079Ark Aerospace LLC · Fort Walton Beach, FLBuilt 1975 · S/N 15077087N6308GDreher Easton · Wis Dells, WIBuilt 1970 · S/N 15071808N63091Hobbs Kole T · Greenville, TXBuilt 1975 · S/N 15077098N63092Lozano Jorge L · Miami, FLS/N 15077099N63095Boyle Daniel K · Llano, TXBuilt 1975 · S/N 15077101N6309GJohnson Robert W · Lebanon, TNS/N 15071809N6309SRegistered aircraftBuilt 1967 · S/N 15067109N6310GAerostar Management Services LLC · Kissimmee, FLS/N 15071810N63114Rgw Aviation LLC · Wilmington, DEBuilt 1975 · S/N 15077113N63120Dean James J · Tampa, FLBuilt 1975 · S/N 15077116N63121Aba Contractors Inc · Arcadia, OKBuilt 1975 · S/N 15077117N63122Registered aircraftBuilt 1975 · S/N 15077118N63125Registration Pending · Burnsville, MNRegistration pendingBuilt 1975 · S/N 15077121N63126Aero Marine Inc · Westland, MIBuilt 1975 · S/N 15077122N6312GAshe Robert W · Bethel, CTBuilt 1970 · S/N 15071812
Back to AD 2009-10-09 R2