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.

N46DHMusgrave John R · Morris, ILS/N 369N46DJBullough William Ronald · Ocala, FLBuilt 2012 · S/N 144SRN46DMEdwards John Guerrant · Stoneville, NCBuilt 1979 · S/N TH-1048N46DTEagle Ad-Venture LLC · Universal City, TXBuilt 2000 · S/N 29-0254N46DZLuepke Quinn L · Wasilla, AKS/N 001N46EAEssential Aviation LLC · Meridianville, ALBuilt 1970 · S/N 39-79N46EHStar H Aviation LLC · Plano, TXBuilt 1988 · S/N 4608108N46ERAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 27-3649N46ETNicholson Jim · Cody, WYBuilt 2012 · S/N 8-6894N46EXRegistered aircraftBuilt 1993 · S/N 014N46EYFirefly LLC · Del Mar, CABuilt 1985 · S/N 46N46FCCopeland Forrest H · Brentwood, CABuilt 2003 · S/N 60075N46FFFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12874N46FTSerrino Sam K · Youngstown, OHBuilt 2022 · S/N 002N46GLawton Richard L · Durango, COBuilt 1971 · S/N CE-353N46GACrosswind Leasing LLC · Prescott, AZBuilt 2005 · S/N 10627N46GBBuzel George Jr · Trumbull, CTBuilt 1998 · S/N BA-1N46GGSpitzer Helicopter LLC · Wilmington, DEBuilt 2013 · S/N 13519N46HCCammack Howard D · Centennial, COBuilt 2001 · S/N 11236N46HDPrice Jesse · Fargo, NDBuilt 2005 · S/N 42071N46HSBlackburn Aviation Air LLC · Mesa, AZS/N 3430N46HYCelli Consulting LLC · Stockton, CABuilt 2004 · S/N 2264N46JEHood Matthew G · Argyle, TXBuilt 2001 · S/N 24934N46JFTisdell Michael S · Olivia, MNBuilt 1986 · S/N 18268563N46JJWoods Terence R · Ankeny, IABuilt 1981 · S/N D-10375N46JLWeaver Aviation LLC · Yucaipa, CABuilt 1975 · S/N 20-1169N46JRRay Homer A · Petrolia, CABuilt 2025 · S/N P38P-85P/86P-P136N46JTWorldwide Aviation Services LLC · Anderson, SCBuilt 2020 · S/N 001N46JWWerner John D · Pownal, VTBuilt 1969 · S/N 17257942N46KBBoatright Kyle W · Marietta, GABuilt 2001 · S/N 20343N46KRPeterson Aviation LLC · Texarkana, TXS/N PO3884N46LAMagoon Paul J · Merrimack, NHBuilt 1986 · S/N 46-8608055N46LEKepley Aviation LLC · Smyrna, TNS/N E726N46LULetourneau University · Longview, TXBuilt 2017 · S/N 4496415N46MJones Gregory D · Pueblo, COBuilt 1958 · S/N 24-411N46MBAig Aeronautics LLC · Guaynabo, PRBuilt 1984 · S/N 46-8508021N46MGHughes Shaun · Everett, WABuilt 1988 · S/N 4608136N46MMHoover Travis F · Mountain View, OKS/N D-5496N46MPAnderson Howard E · Luray, VABuilt 1983 · S/N 172RG1144N46MRDavin Matthew · Ridgecrest, CABuilt 1975 · S/N 21060778N46MUMedic Choppers LLC · Springdale, ARS/N 253N46PAAyer William S · Bellevue, WABuilt 1984 · S/N 46-8408060N46PCMace Robert C Jr · Gold Canyon, AZS/N 21060105N46PGRegistered aircraftBuilt 1972 · S/N 18261414N46PKTensas Taildraggers LLC · Saint Joseph, LABuilt 1978 · S/N U20604437N46PNNuss Paul E Sr · Martinsburg, PABuilt 2013 · S/N PN-001N46RERocks Aero LLC · Carbondale, COBuilt 2000 · S/N 22600N46RKAir Positive LLC · Selbyville, DEBuilt 1969 · S/N 310P0122N46RRAma Aviation LLC · Dover, PABuilt 1987 · S/N 3206004N46RSHixson Steven D · Longview, WAS/N 6-7/8
Back to AD 2007-04-19 R1