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.

N328MDJames Douglas M Trustee · Scottsdale, AZBuilt 1995 · S/N 758-95N328MEFlying Start Aero Services LLC · Reno, NVS/N 172S8575N328NCHenderson Anthony B · Hoschton, GABuilt 1977 · S/N 28R-7737164N328PStrother J Barron · Santa Rosa Beach, FLBuilt 1999 · S/N TH-1916N328PMMayworm Patrick · Mclean, VABuilt 2022 · S/N 3RX116N328RHEchemendia Joel · Kissimmee, FLBuilt 2004 · S/N 1008N328SFast Flight Inc · Springdale, ARBuilt 1969 · S/N D-9068N328SGUp Lights LLC · Jacksonville, FLBuilt 2013 · S/N 1N328SSUnited Helicopter Leasing LLC · Honolulu, HIBuilt 2002 · S/N 1214N328TASuburban Air Corp · Castro Valley, CABuilt 2003 · S/N 172S9328N328TRRufi Craig · Thousand Oaks, CABuilt 2019 · S/N 40555N328VRotors Away LLC · Bayside, NYBuilt 2015 · S/N 13799N328ZPellicone Scott V · Millstone Township, NJBuilt 1960 · S/N CD-226N32903Foxtail Aviation LLC · Orefield, PABuilt 1974 · S/N 28-7515271N32904Sheidler Randy L · Gallipolis, OHBuilt 1974 · S/N 28-7515272N32906Benson Brian R · Mauston, WIBuilt 1974 · S/N 28-7515273N32909Zamarripa Hector · Brownsville, TXBuilt 1970 · S/N 18260423N3290QCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1977 · S/N 28-7716147N3290XBirman Pablo E · Suamico, WIBuilt 1967 · S/N 310L-0140N3291EKukuchka Ronald G · Tunkhannock, PABuilt 1978 · S/N 17271493N3291FEvans Derek M · Fresno, CABuilt 1967 · S/N 670384N3291SRegistration Pending · Highland, ILRegistration pendingBuilt 1964 · S/N 18255791N3292FGoodwin Darrell W · Richmond, TXBuilt 1967 · S/N 670385N3292MHyannis Air Service Inc · Hyannis, MAS/N 402C0304N3292PCrosswindz Ranch LLC · Seminole, TXS/N 23-1242N3292TCelestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1967 · S/N 17700592N3292UAnnecchini Frank C Jr · Overland Park, KSBuilt 1963 · S/N 18254692N3292WOldenkamp Daryl · Hermosa Beach, CAS/N 32-125N3292ZAlbertson James M · Westville, FLBuilt 1959 · S/N 18-7229N32932Gilbert Roy S · Mechanicsville, VABuilt 1974 · S/N 28-7515276N3293BHuttunen Alice D Trustee · Wasilla, AKBuilt 1954 · S/N 18-3287N3293DGuilliams Carl · Gilbert, AZBuilt 1955 · S/N 32091N3293FYe Xiaofeng · Los Gatos, CABuilt 1968 · S/N 680001N3293QRegistration Pending · Gainesville, TXRegistration pendingBuilt 1977 · S/N 28-7790447N3293RBrook Jacob C · Broken Arrow, OKBuilt 1969 · S/N 28R-31264N3293VMckinney Brian · Lakeville, MNBuilt 1995 · S/N 80N3293YKiedinger John D · Burleson, TXS/N 18254293N3293ZStraight And Leve Aeromedical LLC · Billings, MTS/N 18-7230N32942Bent James L Jr DBA · Palatine Bridge, NYS/N 18-7231N32947Alpe Holding LLC · Van Nuys, CABuilt 1974 · S/N 28-7515279N3294CNorwood Kent L · Springfield, MOBuilt 2015 · S/N 90649N3294FWatkins Grant M · Durant, OKBuilt 1967 · S/N 670387N3294RMurray Dennis P · Malta, NYBuilt 1969 · S/N 28R-31265N3294TWolniansky Peter W · Ocean Grove, NJS/N 17700594N3294UWidener Christine A · Tucson, AZBuilt 1963 · S/N 18254694N32956Meritt Kendall E · Wayne City, ILBuilt 1974 · S/N 28-7510035N3295WChapman Daniel H Jr · Ontario, CABuilt 1965 · S/N 32-128N3295YReid Brian M · Boise, IDS/N 18254295N32969Henry Robert K · Knoxville, TNBuilt 1974 · S/N 28-7515282N3296BCommand-Aire LLC · Coatesville, PABuilt 2000 · S/N 14673
Back to AD 2007-04-19 R1