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.

N34821Gibbs Keith L · Eaton Rapids, MIBuilt 1973 · S/N 17702025N34823Eight Twenty Three LLC · Santa Barbara, CABuilt 1973 · S/N 17702026N34829Woods Roderick D · Collierville, TNBuilt 1974 · S/N 17702029N3482THaskell Thomas Edward · Georgetown, TXBuilt 1968 · S/N 17700782N3482UMitchell Philip T · Moreland, GABuilt 1963 · S/N 18254882N3482XCollins Dallas · Columbia, SCBuilt 1966 · S/N 3422N34830Airworx LLC · Gotha, FLBuilt 1973 · S/N 17702030N34833Dallman Bruce D · Terre Haute, INBuilt 1973 · S/N 17702032N34835Saddleback Enterprises LLC · Newport Beach, CABuilt 1973 · S/N 17702033N3483RCentury White Worldwide Inc · Casper, WYBuilt 1968 · S/N 18258783N3483SHickey Bill J · La Veta, COBuilt 1964 · S/N 18255883N3483TCalhoun Edward J · Whitney, NEBuilt 1968 · S/N 17700783N3483UPool Robert Brooks · Lake Charles, LABuilt 1963 · S/N 18254883N3483WSale Reported · Lubbock, TXSale reportedBuilt 1966 · S/N 32-361N3483XDoddy Del · Cincinnati, OHS/N 1155N3483YGrimes William H · Seabrook, SCBuilt 1968 · S/N 18051983N34845Ccf Ventures Inc · Bangor, MES/N 17702039N34847Hanna David G · Imperial, NEBuilt 1973 · S/N 17702041N3484MNiner One Aviation LLC · Hillsboro, ORBuilt 1947 · S/N 12-2080N3484NPietsch Warren A · Minot, NDBuilt 1967 · S/N 680067N3484RTouch And Go Aviation LLC · Jackson, MNBuilt 1968 · S/N 18258784N3484TCairo Jane LLC · Ponca City, OKBuilt 1968 · S/N 17700784N3484YSport Obermeyer Ltd · Aspen, COBuilt 1968 · S/N 18051984N34850Axs Sourcing It LLC · Chugiak, AKBuilt 1973 · S/N 17702044N34852Pride Electric Enterprises · Prescott Valley, AZBuilt 1973 · S/N 17702046N34858Schmid Walter Allen · Fruitland, IDFirst renewal noticeBuilt 1973 · S/N 17702049N3485LEhalt Christopher J · Lester Prairie, MNBuilt 1967 · S/N U206-0785N3485SThorp Contractors LLC · Vinita, OKBuilt 1964 · S/N 18255885N3485WKemp James A · Deland, FLBuilt 1966 · S/N 32-363N3485XCdm Flight Club Inc · La Jolla, CABuilt 1966 · S/N 1157N3485ZVarco John M · Palmer, AKBuilt 1960 · S/N 18-7317N34860Pittman Charles R Trustee · Waterloo, ILBuilt 1973 · S/N 17702051N34865Schmedeman Andrew J · Sanford, FLBuilt 1973 · S/N 17702053N34868Leonard Isaacs Aviation LLC · Fairfield, TXBuilt 1973 · S/N 17702056N3486NRose Thomas Z · Santa Ana, CABuilt 1967 · S/N 680068N3486RMorrissey David H · Queensbury, NYBuilt 1969 · S/N 28-5701N3486UZhills Pilot LLC · Zephyrhills, FLBuilt 1963 · S/N 18254886N3486WSteele Jackie L · London, KYBuilt 1966 · S/N 32-364N3486XLaas Enterprises Inc · Warrens, WIBuilt 1966 · S/N 3423N34873Payne Richard L · Flint Hill, VABuilt 1973 · S/N 17702058N34876Clear Sky Flyers LLC · Lincoln, NEBuilt 1973 · S/N 17702059N3487QIsrael Jonathan · Huntington Beach, CABuilt 1977 · S/N 28-7716159N3487SAscent Investments LLC · Kasota, MNS/N 18255887N3487ULawser Ron · Townsend, MTBuilt 1963 · S/N 18254887N3487XKrzeminski Paul A · San Carlos, CABuilt 1966 · S/N 3424N34886Brooks Aviation LLC · Wilmington, DEBuilt 1974 · S/N 17702064N34888Double J3 Aviation LLC · West Palm Beach, FLS/N 17702066N3488NValley Aviation LLC · Fargo, NDBuilt 1967 · S/N 680070N3488SBarbosa Javier · Edinburg, TXBuilt 1964 · S/N 18255888N3488WLiberty University School Of Aeronautics · Lynchburg, VABuilt 1966 · S/N 32-367
Back to AD 2007-04-19 R1