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.

N704XGByrne Matthew · West Allis, WIBuilt 1976 · S/N 15078951N704XLWelch Donald E · Crown Point, INBuilt 1976 · S/N 15078955N704XNStiefer Charlie C · Durant, OKS/N 15078957N704XSBrian Edward L · La Vergne, TNS/N 15078961N704XVButzer Jeffrey D · Warrens, WIBuilt 1976 · S/N 15078964N704XXSaumer Steven E · Pine City, MNBuilt 1976 · S/N 15078966N704XYWalter Bryce D · Macomb, ILS/N 15078967N704YASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 15078969N704YEMarshall J B · Talbott, TNBuilt 1976 · S/N 15078972N704YLCraig Jason · Upland, CABuilt 1976 · S/N 15078978N704YPFoss Kayla R · Anchorage, AKBuilt 1976 · S/N 15078981N704YRB2w Corporation · Winona, MNBuilt 1976 · S/N 15078983N704YSRepke Robert · Gainesville, GABuilt 1976 · S/N 15078984N704YVHallmark University Inc · San Antonio, TXS/N 15078987N704YWKummer Michael J · Floyds Knobs, INBuilt 1976 · S/N 15078988N704YXMock Joseph R · Huntsville, TXBuilt 1976 · S/N 15078989N704ZDHayward Stephen L · Amarillo, TXBuilt 1976 · S/N 15078995N704ZEPlane Junkies LLC · Dover, DEBuilt 1976 · S/N 15078996N704ZHHouse Robert E Jr · Sanford, NCBuilt 1976 · S/N 15078999N704ZPErickson Elisabeth R · Port Townsend, WABuilt 1976 · S/N 15079005N704ZRLikens Michael K · Labelle, FLBuilt 1976 · S/N 15079007N704ZUWood Donald R · Cottondale, ALBuilt 1976 · S/N 15079010N704ZWOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1976 · S/N 15079012N7050SGrizzle Jason · Roscoe, TXBuilt 1967 · S/N 15067750N7053FAce Aeromotive Inc · Miami, FLS/N 15063653N7058FTechnical Education Services Inc · Virginia Beach, VAS/N 15063658N705TDFlight Gear Aviation LLC · Pickerington, OHS/N 15069561N7060SDygas Pauel · Pomerene, AZS/N 15067760N7061SDirar Farras S E · Sackets Harbor, NYBuilt 1967 · S/N 15067761N7062SPrecision Aerospace Corp · Sarasota, FLBuilt 1967 · S/N 15067762N7064SCuddington Mark E · Puyallup, WAS/N 15067764N7066FLamb Barry J · Moran, KSBuilt 1966 · S/N 15063666N7068FAndrew David N · Manhattan, ILBuilt 1966 · S/N 15063668N7070FDaub David M · Sealy, TXBuilt 1966 · S/N 15063670N7072FMiller Richard M · New Galilee, PABuilt 1966 · S/N 15063672N7072SEstby Hans P · Hayfield, MNBuilt 1967 · S/N 15067772N70739Morey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 15282595N7073FBushby David R · Barnesville, GABuilt 1966 · S/N 15063673N7074SBoening Bros Dust & Spray Svc · Floresville, TXBuilt 1967 · S/N 15067774N7075FGillette Timothy R · Ipswich, MABuilt 1966 · S/N 15063675N7076SHaeg Timothy R · Saint Joseph, MNBuilt 1967 · S/N 15067776N707GSHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279648N707MTams LLC · North Las Vegas, NVS/N 15065924N7081FHayes Travis · Harrisonville, MOBuilt 1966 · S/N 15063681N7081SGustafson Clayton H · Woodbury, CTS/N 15067781N7082FBuchanan Walter C · Yuma, AZBuilt 1966 · S/N 15063682N7084SGreer John M Jr · Mercer Island, WABuilt 1967 · S/N 15067784N7085SMatthews Suzanne M · Horseheads, NYS/N 15067785N7086FCooley Dennis Andrew · Wasilla, AKBuilt 1966 · S/N 15063686N7087FParnell Don E · Alexandria, LAS/N 15063687
Back to AD 2009-10-09 R2