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.

N43MEEvans Matthew B · Granbury, TXBuilt 1978 · S/N P21000046N4414RKirk Ledoux · Stanwood, WABuilt 1979 · S/N U20605111N4422NValiair Lc Trustee · Casper, WYBuilt 1978 · S/N P21000099N4429ETwo Niner LLC · Portola Valley, CAS/N 21064709N4429LShingebiss LLC · Independence, ORBuilt 1982 · S/N 21064647N442GRAk Air Leasing LLC · Homer, AKBuilt 1972 · S/N U20601811N4441WHodge Henry D Jr · Anchorage, AKBuilt 1978 · S/N U20604389N44475Jerryair Ltd · Kent, OHS/N P21000408N444BSSiemens Christopher L · Seminole, TXBuilt 1978 · S/N 21062823N444CLK G L Aviation Inc · Villisca, IABuilt 1975 · S/N 21060910N444FRegistration Pending · Auburn, CARegistration pendingBuilt 1977 · S/N 21061686N444PJWagner Aviation LLC · Laura, OHBuilt 1974 · S/N 21060433N444RWBackus Gary Carl · Chesapeake, VABuilt 1979 · S/N 21063465N448AKN448ak LLC · Helena, MTBuilt 1974 · S/N U20602295N448BBHawkflight LLC · Sugar Land, TXBuilt 1979 · S/N 21063563N44CCoyne Greg · Hondo, TXBuilt 1979 · S/N P21000311N44CFFly Low Aviation LLC · Smithville, MSS/N 21059764N44ECN44ec LLC · Caddo Mills, TXBuilt 1980 · S/N 21063972N44EEEchemann Thomas A · Sidney, OHBuilt 1979 · S/N 21063723N44FATemple Craig A · Fort Lauderdale, FLBuilt 1980 · S/N 20700659N44HRCardinal Aviation Services LLC · Castle Rock, COBuilt 1978 · S/N 21062685N44NTTucker Nicholas B · La Canada, CABuilt 1981 · S/N 21064531N44WHKelly Sean R · Bozeman, MTS/N 21061316N4500KEaston Gregory D · Montrose, COBuilt 1978 · S/N P21000201N450CSCbcb Aircraft LLC · Colfax, WABuilt 1979 · S/N P21000214N450SCSky West Aviation Inc Trustee · Albuquerque, NMS/N P2100294N450SEAok LLC · Omaha, NES/N P21000605N4522KGoodman Jack A · Memphis, TNBuilt 1979 · S/N P21000209N453MCMcneil Kenneth A · Fort Meade, FLS/N 21059844N454GGAk Air Leasing LLC · Homer, AKBuilt 1981 · S/N U20606487N454SVEcliax LLC · Craig, AKBuilt 1981 · S/N U20606524N4561VOrca Wealth Management LLC · New Port Richey, FLBuilt 1976 · S/N U20603052N456BRPressurized LLC · Sequim, WAFirst renewal noticeBuilt 1981 · S/N P21000717N456BWCustom Wholesale Supply Co Inc · Odessa, TXBuilt 1975 · S/N 20700298N456CWSale Reported · Fort Denaud, FLSale reportedBuilt 1982 · S/N 21064676N456MADean Insurance Agency Inc · Crockett, TXS/N U20604325N4570KHead East Aviation LLC · Geneseo, ILBuilt 1979 · S/N P21000220N4576KPope James Dean · Lewiston, IDBuilt 1979 · S/N P21000222N4580KHarrah Daniel R · Juneau, AKBuilt 1979 · S/N P21000223N458DJSurvey America Inc · Rancho Cordova, CABuilt 1980 · S/N U20605833N4594CSt Johns Aviation LLC · Saint Johns, MIBuilt 1979 · S/N 21063569N4596URustair Inc · Anchorage, AKBuilt 1979 · S/N U20604990N45XDSubstation Air LLC · Midvale, UTBuilt 1981 · S/N 21064495N4600UDlw Aviation LLC · Missoula, MTBuilt 1983 · S/N 21064789N4601UChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1983 · S/N 21064790N4601WMike Papa LLC · Newton, KSBuilt 1980 · S/N P21000622N4604QBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 21059504N4605QRichs Air Service · Victoria, KSBuilt 1971 · S/N 21059505N4607QSerrano Lynn A · Casa Grande, AZBuilt 1971 · S/N 21059507N4608CTrinity Property Management LLC · Corvallis, ORS/N 21063572
Back to AD 2002-07-01