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.

N5085SHall Thomas K · Beaufort, NCBuilt 1971 · S/N 28R-7135085N5085VStumpf Douglas D · Aledo, TXBuilt 1977 · S/N VAC74-77N5085WMartin Marlin Ray Jr · Mabank, TXBuilt 1961 · S/N 28-94N5085XAzzalin Giorgio · Jacksonville, FLS/N 158N5086CCalhoun Walter E · Ventura, CABuilt 1978 · S/N 310R1415N5086DGillaspy Paul J · Orcutt, CABuilt 1958 · S/N 51186N5086EPark David W · Placentia, CABuilt 1978 · S/N 17271703N5086LJames Aviation LLC · Marine St Crx, MNS/N 35954N5086NSnoopy Aviation Ltd · San Antonio, TXBuilt 1979 · S/N 18267505N5086RSafety In Motion Flight Center Inc · Puyallup, WABuilt 1974 · S/N 17263324N5086SAero Air Inc · Salt Lake City, UTBuilt 1971 · S/N 28R-7135086N5086XJacono Bruce L · Ramona, CABuilt 1969 · S/N 159N50873Bastien Peter M · Leesburg, VABuilt 1979 · S/N JR-1N5087BSchwebach Victoria L · Coronado, CAS/N 18255988N5087DPenz Johnathan D · Russian Mission, AKBuilt 1958 · S/N 51187N5087JSession Jason E · Higden, ARS/N 17273698N5087KAir Capital Aviators Club · Wichita, KSBuilt 1980 · S/N 17273958N5087SKartchner Stanley J · Tucson, AZBuilt 1980 · S/N R18201502N5087WMcgough Craig N · Lancaster, TXBuilt 1961 · S/N 28-96N5087XRichardson Ethan Mack · Mount Pleasant, SCBuilt 1969 · S/N 160N5087YHansen Dewayne E · Fairbanks, AKBuilt 1962 · S/N 18-7894N5088CMike Golf Holdings LLC · Pinellas Park, FLBuilt 1964 · S/N 30-497N5088DBaughman Jeffrey S · Keller, TXBuilt 1958 · S/N 51188N5088ES J Screw Company Inc T/A · Belvidere, NJBuilt 1979 · S/N 18503931N5088KG & M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 17273959N5088MGeneral Aviation Partners LLC · Madison, ALBuilt 1967 · S/N 28-10928N5088PKesser Gilbert M · Culpeper, VABuilt 1958 · S/N 24-94N5088QMetro Aircraft Co · Bloomington, MNBuilt 2001 · S/N 172S8972N5088RGlacier Equipment LLC · Wasilla, AKBuilt 1974 · S/N 17263326N5088SSwaz Aviation LLC · Mesa, AZBuilt 1971 · S/N 28R-7135089N5088TCox Stephen T · Fairborn, OHBuilt 1968 · S/N MB-343N5088USinnott Simonis Lyle · Girdwood, AKBuilt 1963 · S/N 206-0088N5089C5089c LLC · Fairhope, ALBuilt 1979 · S/N 21063701N5089DMorales Josh S · Anchorage, AKBuilt 1958 · S/N 51189N5089EEgger Gary L · Edmond, OKBuilt 1958 · S/N 50389N5089GFlywell Aviation LLC · Bowling Green, KYBuilt 1979 · S/N 17273538N5089JWentzel Ron · Steamboat Springs, COBuilt 1979 · S/N 17273699N5089RHigh Wing Air Services LLC · Merritt Island, FLBuilt 1974 · S/N 17263327N5089STye Richard Ray · Silverado, CABuilt 1971 · S/N 28R-7130004N5089V89v LLC · Bethlehem, PABuilt 1980 · S/N 18267506N5089YLewis Aaron J · Salado, TXS/N 27-2109N508ADHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2002 · S/N 3290N508AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2020 · S/N 28020007N508BVand Flyve Klub · Newfolden, MNS/N CC18-0015N508BDIron Wings Aviation LLC · Ralph, MIBuilt 1961 · S/N 28-214N508CSJoey Os LLC · Darlington, PABuilt 2006 · S/N 11044N508CXAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2006 · S/N 11074N508DFStephens James Anthony · Baton Rouge, LABuilt 1990 · S/N E2541N508DKTravel Express Aviation LLC · West Chicago, ILBuilt 2002 · S/N 0309N508EJones Ronald C · Walters, OKBuilt 1958 · S/N 50400
Back to AD 2007-04-19 R1