AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
  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.

N3109RHerrera Antonio P · Oxnard, CABuilt 1967 · S/N 18258509N3109TS-J Air LLC · Salem, MOBuilt 1967 · S/N 17700409N3109UBernadt Bruce P · Steinauer, NEBuilt 1962 · S/N 18254509N3109WIII Per LLC · Lewes, DEBuilt 1973 · S/N TE-955N3109YZimmerman Patrick L · Fayetteville, ARBuilt 1994 · S/N 22005CN3109ZMayer Michael · Milford, UTS/N 22-7048N310ACJulie Dorst LLC · Kalispell, MTBuilt 1975 · S/N 310R0290N310ADChang Stephen · Santa Barbara, CABuilt 1976 · S/N 310R0538N310AFSelwa Michael A · Oconomowoc, WIBuilt 1974 · S/N 310Q1121N310AHGraydon Bilal R · Melbourne, FLBuilt 1979 · S/N 310R1660N310AJPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 1980 · S/N 310R1606N310AMCwr Enterprises Inc · Henderson, NCBuilt 1979 · S/N 310R1672N310ARHales Gutter Guys LLC · Cottonwood, AZS/N 310R1387N310ATBelknap Scott M · Temecula, CABuilt 1965 · S/N 310J0097N310AWBetty Eric · Old Hickory, TNBuilt 1969 · S/N 310P0231N310BARampey Alvin H Jr · Atlanta, GABuilt 1975 · S/N 310R0065N310BDSale Reported · Fort Wayne, INSale reportedBuilt 1965 · S/N 310J0013N310BFGv Air Inc · Medford, ORBuilt 1978 · S/N 310R1390N310BGFlairships LLC · Durham, NCBuilt 1977 · S/N 310R0889N310BJJ A Flight Services LLC · Sugar Grove, ILBuilt 1973 · S/N 310Q0759N310BLAlsager Joshua D · Kindred, NDS/N 310Q0069N310BMTeam 67 LLC · Mount Pleasant, IABuilt 1973 · S/N 310Q0987N310BUTar Heel Aviation Inc · Bonita Springs, FLBuilt 1986 · S/N 4608004N310BVExec Air Inc Of Naples · Naples, FLBuilt 1974 · S/N 310R0099N310CBN310cb LLC · Buford, GABuilt 1975 · S/N 310R0600N310CCLance Johnson Ministries Inc · Calhoun, GABuilt 1973 · S/N 310Q0970N310CESwainston Ian · Las Vegas, NVBuilt 1974 · S/N 310Q1063N310CFSouthern Illinois University DBA · Murphysboro, ILBuilt 1975 · S/N 310R0565N310CGHoffert Stephen · Alexander, NCBuilt 1978 · S/N 310R-1304N310CJCj Marketing Inc · Saint John, INS/N 310R0223N310CKSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1980 · S/N 310R-1889N310CLSinclair Bradley W · Melbourne, FLBuilt 1981 · S/N 310R2138N310CPOregon Heli LLC · Bandon, ORS/N S1310N310CTIcp Aviation LLC · Melbourne, ARBuilt 1975 · S/N 310R0570N310CWWahl Charles · Cameron Park, CABuilt 1967 · S/N 310N-0015N310DARecycled Air LLC · Hoschton, GABuilt 1975 · S/N 310R0186N310DDSale Reported · Carmichael, CASale reportedBuilt 1973 · S/N 1502N310DFJordan Air Inc · Hugoton, KSBuilt 1976 · S/N 310R0683N310DHFavero Robert B · Weed, CABuilt 1974 · S/N 310Q1086N310DLPuzio Scott M · Locust Grove, GABuilt 1966 · S/N 310K0191N310DSWorld Marketing Syndicate I · Wilmington, DEBuilt 1977 · S/N 310R0925N310EBWeatherproof Montana LLC · Missoula, MTBuilt 1956 · S/N 35446N310ECState Of Tennessee · Nashville, TNBuilt 1988 · S/N TH-1534N310EDWilson Joseph E W · Austell, GABuilt 1975 · S/N 310R0208N310EFMatherne Aviation LLC · Houma, LABuilt 1975 · S/N 28-7515300N310EKCassel Paul · Hernando, MSBuilt 1973 · S/N 310Q1009N310EMTc Aviation LLC · Atlanta, GABuilt 1988 · S/N 46-08109N310ERAlbrecht Wallace L · Fayetteville, TXBuilt 1966 · S/N 310K0187N310ESDiamond P Aviation LLC · Riverton, ILBuilt 1973 · S/N 310Q0714N310EVMission Air Capital Services LLC · San Antonio, TXBuilt 1978 · S/N 32-7940024
Back to AD 2007-04-19 R1