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.

N275TBDownwind LLC · Olathe, KSBuilt 1991 · S/N 1159N275TCQualitair LLC Trustee · MichelstadtBuilt 1994 · S/N E2914N275TMShank Lee M · Iron Station, NCBuilt 1979 · S/N 32-7940275N275TXQualitair LLC Trustee · MichelstadtBuilt 2015 · S/N 172S11635N275VFly Collier LLC · Naples, FLBuilt 1973 · S/N TH-376N275WYHeileman Michael P · Pewaukee, WIBuilt 2017 · S/N 3275N275ZZWardell Robert · Montrose AuNon-citizen corporation, flight hours not reportedBuilt 1976 · S/N 18503238N2760PDickerson Gary M · Homer, AKBuilt 1955 · S/N 22-3070N2760WHardin Robert S · Renton, WABuilt 1966 · S/N 1050N2760YSanders Flight Training Inc · Jasper, ALBuilt 1958 · S/N TD-126N2761GMartinell Justin E · Dell, MTBuilt 1959 · S/N 52061N2761PCarlin Thomas J · N Richland Hills, TXBuilt 1955 · S/N 22-3071N2761TSmith Corey J · Liberty Township, OHBuilt 1967 · S/N D-8492N2762ADorman Richard E · Mesa, WABuilt 1957 · S/N 32849N2762FFreflite LLC · Wilmington, DEBuilt 1966 · S/N 18256862N2762WRouth Frank D · Marion, NCBuilt 1966 · S/N 1052N2762YFisher Global LLC · Conway, ARBuilt 1958 · S/N TD-129N27634Middaugh Terry E · Chattaroy, WABuilt 1952 · S/N G-15N2763FSeawings LLC · Holualoa, HIBuilt 1965 · S/N 18256863N2763TOrmsby Stephen J · Somerville, OHBuilt 1967 · S/N D-8469N2763XThompson Lyndon R · West Fargo, NDBuilt 1965 · S/N 18051563N2764JMcgregor Daniel A · Denali Park, AKBuilt 1969 · S/N 185-1514N2764PBrine William R · Pahrump, NVS/N 22-3075N2764QLong Donald G Jr · Gaston, ORBuilt 1967 · S/N 18257964N2764YChennault Flying Services LLC · North Las Vegas, NVBuilt 1958 · S/N TD-128N2765FStoup Lyndal K · Cordell, OKBuilt 1965 · S/N 18256865N2765QHoney B LLC · Hillsboro, ORS/N 28-7716121N2765WBriseno Anthony · Virginia Beach, VABuilt 1966 · S/N 1168N2765XBa Aviation LLC · Anacortes, WAS/N 18051565N2766FBrach Raymond S · Henderson, NVBuilt 1966 · S/N 18256866N2766MDahl Jerome M · Iron River, MIBuilt 1977 · S/N 28-7816309N2766PMarti Larry B · Rolla, MOS/N 22-3077N2766QThree Airmigos LLC · New Port Richey, FLBuilt 1967 · S/N 18257966N2767GBrowns Valley Aviation LLC · Utica, KYS/N 52067N2767MNew Ulm Flight Services LLC · Marshall, MNBuilt 1977 · S/N 28-7890266N2767PMatta Sam · Brookshire, TXBuilt 1976 · S/N 255-76N2767TCarr Jeffrey L · Hot Springs, ARBuilt 1967 · S/N D-8476N2767WMorrow Frank D · Wooster, OHBuilt 1966 · S/N 1055N2768GCarrion John H · Colusa, CABuilt 1959 · S/N 52068N2768JRussell Mark Alex · Fairbanks, AKBuilt 1969 · S/N 185-1518N2768TNorth Wind Aviation LLC · Chelan, WABuilt 1967 · S/N CD-1107N2768WGlenn Larry W · Bunn, NCBuilt 1966 · S/N 3355N2768XMullett James L · Mccall, IDBuilt 1965 · S/N 18051568N2769AParish Theodore P · Anchorage, AKBuilt 1952 · S/N 25017N2769FMatthews George W · Hillsboro, OHBuilt 1965 · S/N 18256869N2769GFraser Kevin J · Snohomish, WABuilt 1959 · S/N 52069N2769QPrecision Truck Equipment Inc · Lansing, ILBuilt 1967 · S/N 18257969N2769TRakhmatulin Evgeny A · Carlsbad, CABuilt 1967 · S/N D-8477N2769WHarper Leonard D · Peyton, COBuilt 1966 · S/N 3356N276AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881811
Back to AD 2007-04-19 R1