AD 2002-25-07
Registered aircraft · 542
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-25-07')
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-25-07')
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.
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-25-07') 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-25-07') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N362ALMarks Lloyd · Lafayette, LAN370DPDodson International Parts Inc · Rantoul, KSN3777MRotor Co · New Braunfels, TXN377LFHelicopter Parts International Inc · Minden, NVN378JCLongranger IV LLC · Missoula, MTN383SHAspen Helicopters Inc · Oxnard, CAN385RLSan Juan Aviation LLC · Wilmington, DEN386VCCounty Of Volusia · Deland, FLN38885Back Nine Aerial LLC · New Berlin, WIN388JCSweetwater Landing LLC · Helena, MTN3893UMonarch Enterprises Inc · Kirkland, WAN3895DMonarch Enterprises Inc · Kirkland, WAN38960Greystones Aviation Worldwide Inc · Dulles, VAN38BZHelicopters Inc · Wilmington, DEN38QHawkeye Helicopter LLC · Lyndon, KSN38THGlobal Aerials Inc · Pembroke Pines, FLN393SSouthwest Heliservices LLC · Mesa, AZN395AEAir Evac Ems Inc · O Fallon, MON396RLMorris Equipment LLC · Yuma, AZN397RLBank Of Utah Trustee · Salt Lake City, UTN399AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN399MHBlade Leasing LLC · Homer, AKN39LRHornet LLC · Picayune, MSN3KYCommonwealth Of Kentucky · Frankfort, KYFirst renewal noticeN3QYHelicopters Inc · Wilmington, DEN401FNNy On Air LLC · Kearny, NJN401FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLFirst renewal noticeN402AEAir Evac Ems Inc · O Fallon, MON402FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLFirst renewal noticeN402TDAir Metro Helicopters Inc · New City, NYN404AEAir Evac Ems Inc · O Fallon, MON404MPIndustrial Helicopters LLC · Lafayette, LAN405LPGm Leasing Co LLC · Broussard, LAN405RLGlobal Aviation Florida LLC · Pompano Beach, FLN406KKKehler Kelly · Saint Xavier, MTN406MPGm Leasing Co LLC · Broussard, LAN406PWBank Of Utah Trustee · Salt Lake City, UTN406WHHeli-Works Flight Services LLC · Deer Lodge, MTN407AEAir Evac Ems Inc · O Fallon, MON408AEAir Evac Ems Inc · O Fallon, MON409AEAir Evac Ems Inc · O Fallon, MON410AEAir Evac Ems Inc · O Fallon, MON412KKElkhorn Aviation Inc · Baker City, ORN413TVTri Rotor Spray & Chemical · Ulysses, KSN414AEAir Evac Ems Inc · O Fallon, MON415AEAir Evac Ems Inc · O Fallon, MON416AEAir Evac Ems Inc · O Fallon, MON417AEAir Evac Ems Inc · O Fallon, MON4180FCaswell Farms · Durham, CAN418AEAir Evac Ems Inc · O Fallon, MO
Back to AD 2002-25-07