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.

N3672CWells William · Cary, NCBuilt 1978 · S/N R18200303N3672KEgbert Colton T · Fernley, NVFirst renewal noticeBuilt 1967 · S/N 28-23682N3672NSonger Dylan · Veedersburg, INBuilt 1967 · S/N 680030N3672PSinnott-Simonis Lyle · Girdwood, AKBuilt 1955 · S/N 18-4571N3672QDye Laura G · Whispering Pines, NCBuilt 1967 · S/N MA-262N3672UD W Clark LLC · Newton, NJBuilt 1963 · S/N 18255072N3672YN3672y LLC · Ferrysburg, MIBuilt 1963 · S/N 21058172N36730Jones Kevin B · Mineral Wells, TXBuilt 1978 · S/N 32R-7885206N3673MBeacon Park Pointe LLC · Orlando, FLBuilt 1978 · S/N 32-7840069N3673PWikle Lori Ann · Glennallen, AKBuilt 1955 · S/N 18-4572N3673RArtie Aircraft LLC · Trenton, MOBuilt 1980 · S/N TH-1150N3673UCastor Care LLC · Mount Pleasant, SCBuilt 1980 · S/N TH-1149N3673ZMcmahan Harley B · Gakona, AKBuilt 1960 · S/N 18-7398N36749Air Smt LLC · Powell, OHBuilt 1978 · S/N 28R-7837291N3674DUS Flight Academy International Inc DBA · Post, TXBuilt 1956 · S/N 35374N3674GSudduth Ronald C · Lineville, ALBuilt 1980 · S/N TH-1151N3674NWitt Larry · Waco, TXBuilt 1967 · S/N 680032N3674ZLohse William F · Carter, MTBuilt 1960 · S/N 18-7399N36755Smith Andrew J · Port Alsworth, AKBuilt 1941 · S/N 8168N3675CBergstrom Dean A · Watertown, CTBuilt 1954 · S/N 31174N3675QSwann Phyllis R · Madison, ALBuilt 1967 · S/N MA-266N3675RCl1 LLC · Baton Rouge, LABuilt 1980 · S/N E-1711N3675TFairbairn Stephen C · Carmel, INBuilt 1980 · S/N E-1672N3675WWilson Ag Consulting LLC · Boise, IDBuilt 1966 · S/N 32-584N3675YShettle Jay E · Berryville, VABuilt 1963 · S/N 21058175N3675ZStangel Richard C · Enterprise, ORBuilt 1960 · S/N 18-7401N36768Miller Thomas O · Ingalls, KSBuilt 1973 · S/N 277-73N3676CBoyce Walter Doug · Palmer, AKS/N 31175N3676EPiper Aircraft Inc · Vero Beach, FLBuilt 1977 · S/N 36-7960048N3676LAssociated Aircraft LLC · San Diego, CABuilt 1978 · S/N 0821N3676PThomas Steve L · Presho, SDBuilt 1956 · S/N 18-4575N3676QJobe Eric J · Parkville, MOBuilt 1967 · S/N MA-267N3676RRaider Aviation LLC · Lubbock, TXBuilt 1969 · S/N 28-5779N3676UGregg Michael · Orlando, FLBuilt 1963 · S/N 18255076N3676XLeszczynski Walter D · Georgetown, KYBuilt 1969 · S/N 321N3676ZWhisair LLC · Little Rock, ARBuilt 1960 · S/N 18-7402N36773Scootair LLC · Alburgh, VTS/N 395-73N36774Mader David B · Biddle, MTBuilt 1973 · S/N 594-73N36777Litwin Linda J · Potomac, MDBuilt 1978 · S/N 28R-7837292N3677MKetchum Jeremy W · Wasilla, AKBuilt 1947 · S/N 12-2531N3677PZimmerman Harvey · Shelby, OHBuilt 1956 · S/N 18-4576N3677UNinomiya James T · Placitas, NMBuilt 1980 · S/N TC-2337N3677WGriffith Chad Wayne · Crosby, TXBuilt 1966 · S/N 32-586N36781Addison Thomas P · Haines City, FLBuilt 1978 · S/N 32R-7885208N36787Manairco Inc · Wooster, OHBuilt 2004 · S/N E-3587N36789Paschke Jay · Weatherford, TXBuilt 1978 · S/N 28-7890530N3678LAerojet Services Inc · Aurora, COBuilt 1978 · S/N 0822N3678MCometair LLC · Greensboro, NCBuilt 1978 · S/N 32-7840070N3678PFriemel & Sons LLC · Groom, TXS/N 18-4578N3678UCaven Dennis L · Santa Rosa, CABuilt 1963 · S/N 18255078
Back to AD 2007-04-19 R1