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.

N3067EGlass Bruce D · Crystal Lake, ILBuilt 1982 · S/N 18268231N3067FMisty Air LLC · Parker, COBuilt 2004 · S/N 81664N3067KLynch Alan J · Auburn, WABuilt 1978 · S/N 28R-7918006N3067LT&G Aviation Services LLC · Temple, TXBuilt 2007 · S/N 4191N3067RSmith Julia L · Big Bear City, CABuilt 1969 · S/N 28R-35627N3067YRegistration Pending · Bluffdale, UTRegistration pendingBuilt 1962 · S/N 18254067N30680Smith Ronald D · Anderson, INBuilt 1969 · S/N 17701401N30685Blanchette George · Longwood, FLBuilt 1969 · S/N 17701404N30686Tullos Morgan P · Austin, TXBuilt 1969 · S/N 17701405N3068FLehrman Walter M · Reedley, CABuilt 1966 · S/N 18257168N3068LMirage Air Ltd · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 310J0068N3068NAlpine Air Aviation LLC · West Haven, UTBuilt 2007 · S/N 4202N3068RIsland Aero LLC · Kailua, HIFirst renewal noticeBuilt 1969 · S/N 28R-35629N3068WSneebler Transport LLC · Burke, VABuilt 1973 · S/N E-490N30691Hayden Boyce · Grand Rapids, MIBuilt 1969 · S/N 17701407N30695Beck Paul D · Russell, IAS/N 17701409N30697Rl Flyers LLC · Dover, DEBuilt 1978 · S/N 32-7840124N3069DSmith Gregory E · White Lake, MIBuilt 1956 · S/N 35269N3069FBlaine Barry A · Campbell, CABuilt 1966 · S/N 18257169N3069LGrech George A Trustee · Concord, CABuilt 1979 · S/N 28-7990263N3069NKinzie Hon K · Anchorage, AKBuilt 2007 · S/N 11930N3069QMarin Alberto · Mc Neal, AZS/N 18258069N3069RBean Sheila L · San Antonio, TXBuilt 1969 · S/N 28R-35630N306ACHough Robert M · Windham, NHBuilt 2001 · S/N 1306-2000N306AKRobinson Thomas F II · Port Charlotte, FLBuilt 1966 · S/N 30-1253N306CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13082N306CDDesantis Michael J · Port Orange, FLBuilt 2005 · S/N 1355N306DCEngeman Charles E · Charlotte, NCBuilt 2002 · S/N 0366N306DMWylie Aviation LLC · North Little Rock, ARBuilt 1974 · S/N 18262544N306DPHer Airway LLC · Boca Grande, FLBuilt 2016 · S/N 172S11736N306HBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12968N306LJAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881496N306LTSteiner Glenn C · San Jose, CAFirst renewal noticeBuilt 1974 · S/N 32-7340111N306MBSpitzer Helicopter LLC · Woodland Hills, CABuilt 2016 · S/N 2439N306MGGeorgia Aviation Authority · Eastman, GABuilt 2026 · S/N 28010010N306PMBc 414 LLC · Vineyard Haven, MABuilt 1979 · S/N 414A0419N306PPSl Aviation LLC · Seattle, WABuilt 2010 · S/N 172S11042N306RACoen Peter G · Newport News, VABuilt 1977 · S/N 12898N306TBApex Aviation Holding LLC · Kalispell, MTBuilt 1982 · S/N 340A1537N306TCN306tc LLC · Greenwich, CTBuilt 1976 · S/N 18503061N306VAVeracity Aviation LLC · Seguin, TXBuilt 2025 · S/N 30111N30708Johnson Raymond W · Buffalo, MNBuilt 1969 · S/N 17701414N30709Wessels Jr Steven A · Milledgeville, GABuilt 1969 · S/N 17701415N3070LClark Kenneth N · Tempe, AZBuilt 1965 · S/N 310J0070N3070PParker Anthony C · New Ipswich, NHBuilt 1957 · S/N 23-988N3070SMat-Su Helicopter Training LLC · Wasilla, AKBuilt 2007 · S/N 4217N3070TJacobson Jeffery L · Manning, NDBuilt 1987 · S/N EA-462N3070WEtw Holdings Corp · Owego, NYBuilt 1973 · S/N TC-1626N3070YPearce Andrew R · Raleigh, NCBuilt 1962 · S/N 18254070N30713Wallace James Ray · Baltimore, MDBuilt 1970 · S/N 17701417
Back to AD 2007-04-19 R1