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.

N378BJenkins Kenneth S · Milton Freewater, ORS/N D-5156N378BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881778N378BPBlue Sky Education Inc · Louisville, KYBuilt 1964 · S/N 28-1547N378CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13260N378DSMaya Air Services LLC · Lee, NHBuilt 2004 · S/N 40.442N378FJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 40076N378GPE Graham Investments LLC · Sanford, FLBuilt 1975 · S/N CE-602N378JRay Preston C · Chula Vista, CABuilt 1967 · S/N D-8421N378JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020078N378JGByrkit Dale D · Clay Center, NEBuilt 1992 · S/N 680-92N378JPN8zw LLC · East Hampton, NYBuilt 2005 · S/N 980-2005N378MManly Michael · Lake Panasoffkee, FLBuilt 2007 · S/N CC18-0022N378MARussell Robert Q · Genoa City, WIBuilt 1999 · S/N 172S8078N378RSKempton Larry J III · Grand Junction, COBuilt 1978 · S/N 28R-7837239N378SStarr William E · Eagle River, AKBuilt 1979 · S/N U20604967N378SPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N U20606322N378TCampisi James R · Senoia, GABuilt 1963 · S/N D-7149N378VSSuciv Andronic · Orangevale, CAS/N 886N378WMHelo Holdings LLC · South Fork, COBuilt 2024 · S/N 14810N378ZHamilton Christopher · Dallas, TXS/N CD-266N3790WScudder Adam J · Orlando, FLS/N 32-715N3791DRoberts James O · Billings, MTBuilt 1957 · S/N 34491N3791TMakowski Edward J · Barberton, OHBuilt 1967 · S/N 28R-30104N3791UHarway Inc · Rockingham, NCBuilt 1964 · S/N 18255191N3791WCherokee Trail Aviation LLC · Tontitown, ARBuilt 1966 · S/N 32-717N3791YSatanta Flying Service Inc · Satanta, KSBuilt 1964 · S/N 21058291N3792GNogle Charles H · Champaign, ILS/N G-770N3792TBrowning Marvin Robert · Berthoud, COBuilt 1967 · S/N 28R-30105N3792WFrazer Thomas · Warren, ARBuilt 1966 · S/N 32-719N3793MVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1947 · S/N 12-2718N3793QMartin Tully T · Idalou, TXBuilt 1967 · S/N D-8418N3793UFly Direct Inc · La Porte, INBuilt 1963 · S/N 18255193N3793WBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 32-720N3793YBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1964 · S/N 21058293N3793ZHentges Jerry J · Morris, MNS/N 18-7479N3794DDelahousie David L · Apple Valley, CAFirst renewal noticeBuilt 1957 · S/N 34494N3794K10 Skies LLC · Rockport, TXBuilt 1967 · S/N 28-23731N3794NLc Aviation LLC · Hartland, WIS/N 680120N3794PBellamy Flying LLC · Elwood, NEBuilt 1955 · S/N 18-4694N3795QGreen Aviation Inc · Manchester, MEBuilt 1967 · S/N TE-328N3795TCrossen Executive LLC · Missouri City, TXBuilt 1967 · S/N 28R-30108N3795WWendt Aaron · Temecula, CABuilt 1966 · S/N 32-722N3795ZDieffenderfer John C · Palmer, AKBuilt 1960 · S/N 18-7486N37960Buth Eugene · Wellborn, TXBuilt 1979 · S/N 1306N3796692nd West Aviation Inc · Lonoke, ARS/N 1N3796CPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1974 · S/N 402B0803N3796DHowerton Pamela S · Bartlesville, OKBuilt 1957 · S/N 34496N3796GSantos Aviation LLC · Chico, CABuilt 1977 · S/N 310R0914N3796TWhitmore Allen R · Crestview, FLBuilt 1967 · S/N 28R-30109N3797DGeorge Daniel K · West Union, SCBuilt 1957 · S/N 34497
Back to AD 2007-04-19 R1