AD 2002-07-01

Registered aircraft · 3,466

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:2002-07-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
  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.

N36GBSmokey Bay Air Inc · Homer, AKBuilt 1972 · S/N U20601854N36MSFlying Medical Service Inc · Grosse Pointe, MIBuilt 1976 · S/N U20603244N36RWBas Part Sales LLC · Greeley, COBuilt 1981 · S/N P21000691N36XArchangel Aviation LLC · Cleburne, TXBuilt 1976 · S/N 21061650N370JCSouth Oaks Inc · Hollywood, FLBuilt 1977 · S/N U206-04024N370RAmerican Aircraft Management LLC · Irving, TXBuilt 1980 · S/N U20605501N373ARPaul Brightwell Dirtworks Inc · Springer, OKBuilt 1979 · S/N P21000308N373HShumate Johnny E · Spring, TXBuilt 1974 · S/N 21060190N373PJRock Creek Corp · Henderson, NVBuilt 1978 · S/N 21062887N3745PRiviera Aircraft Inc · Lewes, DEBuilt 1978 · S/N P21000052N3746Nickravesh Niknam J · Saratoga, CABuilt 1975 · S/N U20602818N3756XStephens Tanner B · Palmer, AKBuilt 1968 · S/N 21059075N375FDepartment Of The Interior · Boise, IDBuilt 1980 · S/N U20605750N3761PSky Rollers LLC · Merritt Island, FLBuilt 1978 · S/N P21000053N377CFCohen Rolando S · New York, NYBuilt 1974 · S/N 20700275N378SStarr William E · Eagle River, AKBuilt 1979 · S/N U20604967N378SPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N U20606322N3799PCt Services LLC · Albuquerque, NMBuilt 1978 · S/N P21000055N37DPTurbo Time LLC · Mesa, AZBuilt 1976 · S/N 210-61452N37EWKundel Andrew R · Muscatine, IAS/N U20602997N37MJLara-Meza Sergio Giovanni · Mcallen, TXS/N P21000552N37PB37pb Inc · Seattle, WABuilt 1972 · S/N 21059737N381DSFlightpath Investments LLC · Ottumwa, IABuilt 1974 · S/N 21060255N3829PRalphs Thomas A · Solana Beach, CABuilt 1978 · S/N P21000062N382MGMissionary Air Group Inc · Burlington, NCBuilt 1979 · S/N U20605256N383MGMissionary Air Group · Burlington, NCBuilt 1982 · S/N U20606624N384MGMissionary Air Group Inc · Burlington, NCBuilt 1979 · S/N U20605272N3858RBaugh David · Kirkland, WABuilt 1983 · S/N U20606496N3862PBrown Travis Trustee · Columbia, MOS/N P21000065N3886PUncanny Valley Films Inc · Arroyo Seco, NMBuilt 1978 · S/N P21000068N388SStarr William E · Eagle River, AKBuilt 1984 · S/N U20606838N38AZN731ny LLC · Phoenix, AZBuilt 1980 · S/N P21000516N38PFSycan Corp DBA · Paso Robles, CABuilt 1980 · S/N 21063979N390RSSchoene Edward C · Springfield Center, NYBuilt 1976 · S/N 21061514N3912PRegistered aircraftBuilt 1978 · S/N P21000074N391PT7640 Drilling LLC · Amarillo, TXBuilt 1973 · S/N 21060097N391SCSkydive Pennsylvania Inc · Mercer, PABuilt 1969 · S/N U2061405N3923GMiddle Fork Aviation Inc · Challis, IDBuilt 1967 · S/N U206-0923N3927GAerial Transport LLC · Dover, DEBuilt 1967 · S/N U206-0927N3927MTulin Donald J · Anchorage, AKS/N U20604423N3939GThree Niner Gulf L L C · Denver, COBuilt 1967 · S/N U206-0939N393DW3 Delta Whiskey LLC · Superior, WIBuilt 1979 · S/N U20605261N394RAN Registration Service LLC Trustee · Sanford, NCS/N 21059329N39501Jw & Jl Aviation LLC · Phoenix, AZBuilt 1982 · S/N U206-06452N3959POmaha Aircraft LLC · Blair, NES/N P21000075N3962GJoe Sanchez Farms Inc · Walnut Grove, CABuilt 1967 · S/N U206-0962N3968QTundra Wings Ministries · Wasilla, AKBuilt 1975 · S/N U20603037N3970GBack Country Flying Experience Inc · Kalispell, MTBuilt 1967 · S/N U206-0970N3972GCounty Of Merced Sheriff'S Dept · Merced, CABuilt 1967 · S/N U206-0972N3974GStaheli Lee E · Kiana, AKFirst renewal noticeS/N U206-0974
Back to AD 2002-07-01