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.

N398LJDakota Heavy Equipment · Fargo, NDBuilt 1988 · S/N EA-471N398LTHogan William · Deer Lodge, MTBuilt 1964 · S/N D-7406N398MEDesalvo Dennis · St Louis, MOBuilt 2000 · S/N 18280877N398RVInman Michael David · Raeford, NCBuilt 2024 · S/N 82349N398SAGembala Gary L · Strongsville, OHBuilt 1998 · S/N 1824N398SBYuba Sutter Aviation Inc · Olivehurst, CABuilt 1998 · S/N 821-98N398SCBornhoft Jerry · Riverton, WYBuilt 1975 · S/N 18-7509020N398TWaffensmith Walter L Trustee · Golden Valley, MNBuilt 1976 · S/N E-976N398WWaffensmith Walter L Trustee · Golden Valley, MNBuilt 1973 · S/N 18052332N39907Sale Reported · Elizabeth City, NCSale reported, pending cancellationBuilt 1973 · S/N 73-30553N3990DKeselman Michelle V · Las Vegas, NVBuilt 1957 · S/N 34690N3990KPavlicek Gordon · Dickinson, NDS/N 28-23881N3990UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842222N3991AJohnson Douglas H · Rockwall, TXBuilt 1970 · S/N CE-315N3991KIsaacs Brandon · Homedale, IDBuilt 1967 · S/N 28-23882N3991WAllways LLC · Missoula, MTBuilt 1967 · S/N 32-911N3991XPackaging Plus Inc · Fishers, INS/N 28-7515440N3991ZFairbanks Investor LLC · Fairbanks, AKBuilt 1963 · S/N 18-7936N3992DLeyda Aaron M · Bartlesville, OKBuilt 1957 · S/N 34692N3992GFlat Earth LLC · Kalispell, MTS/N U2060992N3992NBoehm Justin K · Cleveland Heights, OHS/N 680016N3992PAir Bear Aviation Inc · North Hampton, NHBuilt 1956 · S/N 18-4752N3992QWisberg Robert E · Bonners Ferry, IDBuilt 1973 · S/N 18502218N3992TDonnelly Charles · Nashua, NHBuilt 1968 · S/N 28R-30347N3992ZGrandy Boyd · Smoot, WYBuilt 1963 · S/N 18-7937N3993RTappan John A · Prosper, TXBuilt 1971 · S/N 28-7105097N3993TAir Alliance Inc · Lexington, KYBuilt 1967 · S/N 28R-30348N3994MRegistered aircraftBuilt 1978 · S/N 32R-7885021N3994NJohnson Gregory H · Thousand Oaks, CABuilt 1968 · S/N 680156N3994QSchneider Don C · Juneau, AKBuilt 1973 · S/N 18502220N3994TViars Thomas P · Riviera Beach, FLBuilt 1968 · S/N 28R-30349N3994WKramer Jeffrey P · Burlington, WIBuilt 1967 · S/N 32-962N3994YCrosco LLC · Canton, OHBuilt 1964 · S/N 21058494N3994ZHastings Stephen J · Wasilla, AKBuilt 1963 · S/N 18-7943N39953Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 28-7916013N39954Swaz Aviation LLC · Mesa, AZBuilt 1978 · S/N 28-7916014N3995AMccoy Keith · Salt Rock, WVBuilt 1978 · S/N 310R1347N3995DNelson Bryce H · Keiser, ARBuilt 1957 · S/N 34695N3995GCutting Edge Design & Contracting-Sc Inc · Elgin, SCBuilt 1968 · S/N U206-0995N3995KKennedy Daniel P · Phoenix, AZS/N 28-23887N3995PMoore Dana C · Chignik Lagoon, AKBuilt 1956 · S/N 18-4756N3995ZRay Richard L · Chugiak, AKBuilt 1963 · S/N 18-7944N39964Sand Box Powder Coating Inc · Elmira, NYBuilt 1978 · S/N 32R-7885245N3996DHeritage Aviation Holdings LLC · Mesquite, NVS/N 34696N3996FGrim William S · Kingwood, TXBuilt 1976 · S/N 28R-7635394N3996KO Conner Kevin E · Carrollton, TXBuilt 1967 · S/N 28-23888N3996NSumner Thurston B III · Ocracoke, NCBuilt 1968 · S/N 680017N3996PWhittock Tyson H · Anchorage, AKBuilt 1956 · S/N 18-4757N3996QLuther Turner S · Perry, FLBuilt 1971 · S/N 17260096N3996ZFlint Paul L · Anchorage, AKBuilt 1963 · S/N 18-7945
Back to AD 2007-04-19 R1