AD 2002-20-05
Registered aircraft · 2,705
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-20-05')
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-20-05')
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-20-05') 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-20-05') 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.
N190RHLiberty Blades LLC · Flandreau, SDN191SGAngel William D · Rancho Cucamonga, CAN192AEAir Evac Ems Inc · O Fallon, MON192RLRotorcraft Leasing Co LLC · Broussard, LAN192TAHawkeye Helicopter LLC · Lyndon, KSN193AETextron Financial Corp · Wichita, KSN193ALBlade Leasing LLC · Homer, AKN193AMAir Methods LLC · Greenwood Village, CON194TAJsj Aviation LLC · Helena, MTN1957ZDakota Rotors LLC · Custer, SDN195DJN195dj LLC · Brooklyn, NYN196AEAir Evac Ems Inc · O Fallon, MON196SJSan Juan Aviation LLC · Wilmington, DEN196TAHelo N426ha LLC · Richmond, VAN197AAChem-Air Inc · Shreveport, LAN197JGlobal Aircraft Trust Inc Trustee · Cheyenne, WYN198HIndustrial Helicopters LLC · Lafayette, LAN198MAMarks Aviation Group LLC · Lafayette, LAFirst renewal noticeN19BHAbc Helicopters Inc · Jefferson, WIN19HXPremier Aircraft Services LLC · Bakersfield, CAN19NGNorgreen Aviation LLC · Kirkland, WAN19WGCorpat Inc · Missoula, MTN1AKMeridian Investments LLC · Anchorage, AKN1MHIsaiah 40v31 LLC · Orlando, FLN1MJLittle Ranger LLC · Jackson, WYN1TNNorman Family Investments LLC · Greenville, TXN2009CMeridian Helicopters LLC · Broussard, LAN200HRSutter Air Inc · Los Banos, CAN200PCRincon Enterprises LLC · Helena, MTN200VBVertical Vegetation Management LLC · Darlington, INN201PAAsa Security LLC · Anchorage, AKN201SMDemo Salvage Inc · Calais, MEN2020ROphthalmology Transport Inc · Opelousas, LAN202MHSouthern Utah University · Cedar City, UTN202PHCoastal Air Services Inc · Panama City, FLN202TPHeartland Aviation LLC · Ada, OKN20316Back Nine Aerial LLC · New Berlin, WIN2036FBell Textron Inc · Fort Worth, TXN203EHDsl Aviation LLC · Perham, MNN203HAHelo N203ha LLC · Richmond, VAN203PAD H Helicopter Inc DBA · Mcminnville, ORN2041XQbl Aviation LLC · Waco, TXN2042XBell Textron Inc · Fort Worth, TXN2043BL&R Investment Partners LLC · Wilmington, DEN204AVSan Juan Aviation LLC · Wilmington, DEN204SWybenga Aviation LLC · Twin Falls, IDN204USBlue Air 2 LLC · Miami, FLN205CPSouthern Helicopters Inc · Sunshine, LAN205EHSacramento Executive Helicopters Inc · Acampo, CAN205FCGm Leasing Co LLC · Broussard, LA
Back to AD 2002-20-05