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.

N381CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12139N381CRSiemsen Randall R · Clovis, CABuilt 1976 · S/N E-875N381DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843844N381DCJackson Richard D · Ninety Six, SCBuilt 2001 · S/N 25265N381DFSouth & Silver Aviation LLC · Pikesville, MDBuilt 1977 · S/N 17269718N381DMStuart John R · Taylorsville, KYBuilt 2000 · S/N 865-2000N381DSFlightpath Investments LLC · Ottumwa, IABuilt 1974 · S/N 21060255N381FCBrown Shane · Ozark, MOBuilt 1976 · S/N 28-7615197N381GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881429N381HBargainnier David R · Reedsville, PABuilt 1957 · S/N 50079N381JUS Aviation Group LLC · Denton, TXBuilt 1980 · S/N 17274183N381LMorgan Fred M · Onancock, VABuilt 1999 · S/N 29-0201N381LJBlue Rudder Aviatoin LLC · Excelsior, MNBuilt 2002 · S/N 2843540N381MAKnight Wings LLC · Matthews, NCBuilt 2005 · S/N 1397-2005N381MBStrobridge Mark D · Bunnell, FLBuilt 1981 · S/N 17275303N381MGMissionary Air Group Inc · Burlington, NCBuilt 1975 · S/N 17265873N381NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881666N381SBettys Beech LLC · Conway, ARBuilt 1968 · S/N TE-629N381TCShumate Frank T · Rockport, TXBuilt 1978 · S/N TK-83N381WGGoodman Bob · Opelika, ALBuilt 2003 · S/N 81657N381XMead Lane · Minocqua, WIBuilt 1976 · S/N 7019CN38204Louw-Defazio Joan Trustee · Temecula, CABuilt 1977 · S/N 28-7710046N38206Bean John R · San Antonio, TXBuilt 1977 · S/N 32R-7780404N38208Jb Airways LLC · Linden, PABuilt 1977 · S/N 32R-7780405N3820LFly A Twin LLC · Kirkland, WABuilt 1981 · S/N TJ-341N3820MIsrael Howard A · Santa Monica, CABuilt 1981 · S/N TC-2372N3820RAnagnos Nick C · East Moline, ILS/N 28-5836N3820T3820t Aviation LLC · Fort Smith, ARBuilt 1967 · S/N 28R-30137N3820XDwyhalo David W · Moorpark, CABuilt 1966 · S/N 310K0220N3820ZBudd Kirkland G · Rushville, NES/N 18-7560N38211Watford Aeroservice LLC · Watford City, NDBuilt 1977 · S/N 28-7716232N38214Mora Steven T · Corning, CABuilt 1977 · S/N 28-7790530N3821FKennedy Karen E · Gulf Breeze, FLBuilt 1977 · S/N 0789N3821GI Am Alpha & Omega LLC · Sparks, NVS/N U206-0821N3821KSoar Above Flight Solutions LLC · Englewood, TNBuilt 1967 · S/N 28-23739N3821PRadach Kenneth D · Copper Center, AKBuilt 1955 · S/N 22-3511N3821TDoty David W · Lakeland, FLBuilt 1968 · S/N 28R-30959N38226Martinex Aviation LLC · Wentzville, MOS/N 32-40281N3822DGifford David M · Las Vegas, NVBuilt 1957 · S/N 34522N3822FBelser Mark · Avon, OHBuilt 1977 · S/N 0790N3822KPerry Park Investments Inc · Larkspur, COBuilt 1981 · S/N EA-192N3822QMatanane Roke C · Barrigada, GUBuilt 1971 · S/N 17259922N3822TVanderblom David Y · Oxford, ALBuilt 1967 · S/N 28R-30139N3822URegistration Pending · Stillwater, MNRegistration pendingBuilt 1981 · S/N D-10364N3823AAndy Downs LLC · Langdon, NDBuilt 1981 · S/N EA-194N3823DPfaff John W · Laytonville, CABuilt 1957 · S/N 34523N3823FGovednik Francis J · Flower Mound, TXBuilt 1977 · S/N 0791N3823WCherokee N3823w LLC · Huntsville, ALFirst renewal noticeBuilt 1966 · S/N 32-755N3823XRegistration Pending · Logan, UTRegistration pendingBuilt 1966 · S/N 310K0223N3823ZFranks Cory B · Idalou, TXBuilt 1960 · S/N 18-7563
Back to AD 2007-04-19 R1