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.

N16KFFournier Louis W · Fort Worth, TXBuilt 1965 · S/N 15061619N16RRAustin Donald E · Ripley, MSBuilt 1979 · S/N 15283120N16SHDickinson James C · Haslet, TXBuilt 1972 · S/N 15073404N17001Shields David A · Saylorsburg, PAS/N 15073572N17004Depietro Shelley Jo · Olympia, WABuilt 1972 · S/N 15073575N17009Wight John I · Anchorage, AKBuilt 1972 · S/N 15073578N1700QAtkinson Jonathan E · Chapmansboro, TNBuilt 1971 · S/N 15073000N17014Alcorn Paul W · Bay City, MIS/N 15073581N17016Mika Brian D · Andover, MNBuilt 1972 · S/N 15073583N17021Fletcher John Guy · Diamondhead, MSS/N 15073587N1702QStrutzenberg Kent R · Manson, IABuilt 1971 · S/N 15073002N17033Browning Brad T · Lake Park, MNBuilt 1972 · S/N 150-73594N17039Davidson Luke H · Gilmer, TXS/N 15073597N1703QTroutman Noah M · Owensboro, KYBuilt 1971 · S/N 15073003N17043Coleman Sherod · Houston, TXBuilt 1972 · S/N 15073600N17045Streichenwein Scott F · Salisbury Mills, NYBuilt 1972 · S/N 15073602N17047Sickinger Alan W · New Philadelphia, OHBuilt 1972 · S/N 15073604N17048Myob Group LLC · Ocala, FLBuilt 1972 · S/N 15073605N17060Jacobsen Lee E · Inchelium, WABuilt 1972 · S/N 15073612N17065Glaser Donald L Jr · Olive Branch, MSS/N 150-73615N17069Joyce Michael P · New Kent, VAS/N 15073619N17077Shehl George William III · Charleston, WVBuilt 1972 · S/N 15073257N1707QGarcia Jorge A · Ponce, PRBuilt 1971 · S/N 15073007N1708QJergovich Jack A · Austin, TXBuilt 1971 · S/N 15073008N17098Lake Michigan Asset Management LLC · Grand Rapids, MIBuilt 1972 · S/N 15073622N170KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1977 · S/N 15079154N170SUTop Flight Consulting LLC · Fort Myers, FLBuilt 1979 · S/N 152-83248N17101Vasquez Juan E · Miami, FLBuilt 1972 · S/N 15073623N17106Tate Daron D Trustee · Pasco, WABuilt 1972 · S/N 15073627N1712QMischief Makers LLC · Tuscaloosa, ALBuilt 1971 · S/N 15073012N17134Trappe Enterprises LLC · Street, MDBuilt 1972 · S/N 15073633N17136Ireland Brian T · Newberg, ORS/N 15073635N1713QMaier Brandon · Eagle Grove, IABuilt 1971 · S/N 15073013N17141Dawson Aircraft Inc · Clinton, ARBuilt 1972 · S/N 15073638N17143Misner Gear K · Phoenix, AZBuilt 1972 · S/N 15073640N1714QRoth Mark E · Stevensville, MTBuilt 1971 · S/N 15073014N17170Cannon Christopher H · Moorpark, CABuilt 1972 · S/N 15073644N17174Davison Mark L · Vacaville, CAS/N 15073648N17176Johns Thomas D · West Hills, CABuilt 1972 · S/N 15073649N17181Hays Jerry W · Heath, TXBuilt 1972 · S/N 15073652N1718QRegistered aircraftS/N 15073018N1719QMartinz Mike · Big Timber, MTBuilt 1971 · S/N 15073019N171RJSawyer Eric O · Redding, CABuilt 1966 · S/N 15063038N17200Horton Andrea L · Auburn, CABuilt 1972 · S/N 15073659N17203Ds Flight Services LLC · Battle Groun, WAS/N 15073662N17205International Air Services Inc Trustee · Carson City, NVS/N 15073664N17210Babler Paul W · Blaine, MNBuilt 1972 · S/N 15073666N17218Papich William · Boston, NYBuilt 1972 · S/N 15073671N17221Gray Jimmie E · Punta Gorda, FLS/N 15073673N17230Chase Melissa L · Port Orange, FLBuilt 1972 · S/N 15073679
Back to AD 2009-10-09 R2