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.

N4783BRogge Gary L · Fowler, COBuilt 1955 · S/N 31681N4783KLandwehr Wayne A · Gill, COBuilt 1979 · S/N P21000314N4783LSikka Dhruv · Lutz, FLBuilt 1967 · S/N 28-4118N4783NPlane Sense LLC · Oregon City, ORBuilt 1979 · S/N 18267366N4783PBush Robert Edward · Mead, WABuilt 1977 · S/N AA5B-0526N4783RFly In Helicopters LLC · Wilmington, DEBuilt 2004 · S/N 10584N4783WCmt Properties Inc · Dover, DEBuilt 1976 · S/N 14113N4784BPhyfe Andrew L · Cape Coral, FLBuilt 1955 · S/N 31682N4784EPeabody Jeffery L · Vinemont, ALBuilt 1978 · S/N 17271649N4784FSullivan Ross Anthony · Saint Helena, CAS/N P206-0384N4784JSale Reported · Crystal, MNSale reportedBuilt 1967 · S/N MB-220N4784LDelta Sierra LLC · Naples, FLBuilt 1967 · S/N 28-4119N4784MTigress IV LLC · California, MDBuilt 1978 · S/N TC-2145N4784YBig Sky Jet Inc · Bozeman, MTBuilt 1968 · S/N 25-4553N4785FSoaring Society Of Boulder Inc · Boulder, COBuilt 1962 · S/N 18-7906N4785LTranswestern Air Service Inc · Golden, COBuilt 1967 · S/N 28-4120N4785NHolden Engineering Inc · Oviedo, FLBuilt 1979 · S/N 18267368N4785SSchiller Matt D · San Francisco, CABuilt 1979 · S/N R18201426N4785UNew England Vascular Access LLC · Bristol, NHBuilt 1983 · S/N 21064816N4785YSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1968 · S/N 25-4556N47868Heartland Airplanes LLC · Olathe, KSFirst renewal noticeS/N 28-7890147N47869N47869 LLC · Spanish Fork, UTBuilt 1977 · S/N 28R-7837008N4786DPierce Stephan L · Graham, TXBuilt 1958 · S/N 34886N4786ETu Erik S · Pasadena, CABuilt 1978 · S/N 17271651N4786FLogan Robert E · Advance, NCBuilt 1968 · S/N P206-0470N4786LZayas Omar · Fontana, CABuilt 1967 · S/N 28-4122N4786QMcgregor Daniel A · Denali Park, AKBuilt 1978 · S/N 18503556N4786SMultiprop Ventures LLC · Danvers, MABuilt 1979 · S/N R18201427N4787AStock Matthew D · Clarence, NYBuilt 1956 · S/N 22-3938N4787ESilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1978 · S/N 17271652N4787SClassic Image Auto LLC · Huntsville, ALS/N R18201428N4787UDreyer Jeffrey J · Payson, AZBuilt 1964 · S/N 18051487N47880Halmon Henry W · Manvel, TXBuilt 1997 · S/N 2500N47881Griffin Jack D · Hamilton, OHBuilt 1977 · S/N 28-7816151N47882Pray Aviation Inc · Augusta, KSBuilt 1977 · S/N 28-7816152N47885Dynasty Adventure Inc · Mentone, CABuilt 1977 · S/N 28-7890148N47886N47886 LLC · Dover, DEBuilt 1977 · S/N 28-7890149N4788DJb Aviation Flight School Inc · Wonder Lake, ILBuilt 1979 · S/N 17272359N4788ETiernan Jeffery P · Waddington, NYBuilt 1978 · S/N 17271653N4788PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N P21000108N4788VM Fujii Inc · Costa Mesa, CABuilt 1980 · S/N 172RG0378N47899Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7816153N4789DStevens Dennis W · Mohave Valley, AZBuilt 1979 · S/N 17272360N4789EPhil Weber Investments LLC · San Diego, CABuilt 1978 · S/N 17271654N4789FGrimes Aero LLC · Hobbs, NMBuilt 1967 · S/N P206-0389N4789JChenault Mitchell Ray · Renton, WABuilt 1967 · S/N MA-209N4789NRegistered aircraftBuilt 1980 · S/N 18267409N478AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843746N478ACModern Mobility LLC · Kennedale, TXBuilt 2024 · S/N 18283272N478ATAirmen Testing And Training Inc · Lantana, FLBuilt 2001 · S/N 1006
Back to AD 2007-04-19 R1