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.

N5533QBoldt Matthew Frederick · Santa Fe, NMBuilt 1965 · S/N 2955N5533RThompson Aaron R · Louisville, KYS/N 172RG0072N5533SNgb Construction Inc · Ceres, CAS/N R18201599N55340Air55 LLC · Charleston, WVBuilt 1973 · S/N 28-7305363N55342Dienwiebel Thomas · Santa Cruz, CAS/N 1183N55345Arrow Flite LLC · Chino Hills, CABuilt 1973 · S/N 28R-7335220N55347Roze Scott L · Port Orange, FLBuilt 1973 · S/N 28-7310129N55349Mob Aviation LLC · Auburndale, FLS/N 17275163N5534ELindsey Kelly M · Throckmorton, TXBuilt 1978 · S/N 17271883N5534KAerolife Aviation LLC · Knox, INBuilt 1978 · S/N 1028-78N5534NClifford English · Mesa, AZBuilt 1980 · S/N 18267776N5534QPaul Richard W · San Jose, CABuilt 1965 · S/N 620N5534RHanson David J · Charlotte, NCBuilt 1990 · S/N E-2576N55350Haps Air Inc · Ames, IABuilt 1982 · S/N 17275164N55359Uribe Roberto · Houston, TXBuilt 1973 · S/N 28R-7335222N5535BAvery John W · Fergus Falls, MNFirst renewal noticeBuilt 1956 · S/N 33535N5535FTrent Donald R · Rustburg, VABuilt 1968 · S/N 28-24934N5535JBreadner Robert A · OntarioNon-citizen corporation, flight hours not reportedBuilt 1967 · S/N 32-998N5535KHays Cory · Beaumont, TXBuilt 1978 · S/N 390-78N5535MButz Jonathan O · Mansfield, OHBuilt 1967 · S/N 121N5535NBerry William Trustee · Harrison, ARBuilt 1980 · S/N 18267777N5535QJohnson Bar Inc · Pensacola, FLBuilt 1965 · S/N 2956N5535WGpd LLC · Saint Louis, MOBuilt 1990 · S/N E2540N55363Hardin John M · Terrell, TXS/N 34-7350206N55364Cremel Roberto J · Trumbull, CTS/N 28-7325384N55367Mammoth Toys Inc · Santa Ana, CABuilt 1990 · S/N E2537N5536BHigh Five Flying LLC · Amarillo, TXBuilt 1956 · S/N 33536N5536DLett Laura D · Dallas, TXBuilt 1957 · S/N D-5086N5536EJeffries And Hendley LLC · Greenwood, INBuilt 1978 · S/N 17271885N5536FArnt James R Jr · Worthington, MNBuilt 1968 · S/N 28-24935N5536JHanna Patricia A · Davis Junction, ILS/N 32-999N5536LAdvance Air LLC · Wichita, KSBuilt 1990 · S/N EA-502N5536NBrown Peter L · Riverton, CTBuilt 1980 · S/N 18267778N5536PGryhon Designs · Camden, SCBuilt 1958 · S/N 24-600N5536QWokini Air LLC · Tarpon Springs, FLS/N 621N5536UPittman Discover Flight LLC · Oshkosh, WIBuilt 1969 · S/N 28-26257N5536WSchilke Kenneth · Imperial, NES/N 28-626N55372Mccarroll Daniel C · Saint Augustine, FLS/N 1188N55374American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275170N55378Iacobacci Timothy · Fairborn, OHBuilt 1973 · S/N 34-7350207N5537CM G Aviation · Tyler, TXBuilt 1979 · S/N 21063785N5537KSales First LLC · Jasper, GABuilt 1978 · S/N 392-78N5537MWiglesworth David G · Lenexa, KSBuilt 1967 · S/N 123N5537PField Gerard · Middleboro, MABuilt 1958 · S/N 24-601N5537RBalady Nabih · Santa Clarita, CABuilt 1979 · S/N 172RG0073N5537SMcpeak Alan W · Colorado Springs, COBuilt 1980 · S/N R18201600N5537VWheelzup LLC · San Carlos, CABuilt 1990 · S/N EA-506N5537XKelly Douglas E · Lake Ozark, MOBuilt 1990 · S/N E-2531N55380Clark Joseph David · Kilgore, TXS/N 28-7325388N55383Winkelman James R · Zionsville, INBuilt 1973 · S/N 28-7305371
Back to AD 2007-04-19 R1