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.
N131WMWestwind Helicopters Inc · Santa Fe, TXN132AEAir Evac Ems Inc · O Fallon, MON1337KJsg Aviation LLC · Wilmington, DEN133AEAir Evac Ems Inc · O Fallon, MON134AEAir Evac Ems Inc · O Fallon, MON134MSSunny Sky LLC · Stacyville, IAN135AMAir Methods LLC · Greenwood Village, CON1368XLinscott Jeffrey R · Boring, ORN136JSBettencourt Flg Svc Inc · Atwater, CAN136TWSilver Creek Aviation Services · Fort Worth, TXN137AGTop Gun Precision Ag LLC · Skidmore, TXN137HSHelicopter Services Of Illinois LLC · Fisher, ILN137MScotts Helicopter Services Inc · Le Sueur, MNN137MMAircraft Guaranty Corp Trustee · Oklahoma City, OKN137MSKansas State University · Salina, KSN137PDPuerto Rico Police Department · San Juan, PRN138AEAir Evac Ems Inc · O Fallon, MON138ARAmentum Services Inc · West Palm Beach, FLN138DDDalton Aviation LLC · Bluffdale, UTN138LHHelilease LLC · Lewes, DEN138PDPuerto Rico Police Department · San Juan, PRN139PDPuerto Rico Police Dept · San Juan, PRN13FBFirebird Holdings LLC · Fort Worth, TXN13FQFly Hangar 13 LLC · Mico, TXN13FV22t Aero LLC · Anchorage, AKN13FWFly Hangar 13 LLC · Mico, TXN13HDHelicopters Inc · Wilmington, DEN13MXBank Of Utah Trustee · Salt Lake City, UTN13NNHelicopters Inc · Wilmington, DEN13QBFly Hangar 13 LLC · Mico, TXN1404WPendley Rory G · Torrance, CAN140HLGm Leasing Company LLC · Broussard, LAN1416Gm Leasing Company LLC · Broussard, LAN141APGm Leasing Co LLC · Broussard, LAN142DPMarks Lloyd · Lafayette, LAN142MAMinuteman Aviation Inc · Missoula, MTN1431WC-Pan Aero LLC · Stratford, CTN1435WFarwest Aviation LLC · Billings, MTN143HBank Of Utah Trustee · Salt Lake City, UTN144BHAbc Helicopters Inc · Jefferson, WIN144MAMinuteman Aviation Inc · Missoula, MTN144TVAir Flite Inc · Shawnee, OKN145LTLt Aviation LLC · Louisa, KYN146SHScott'S Helicopter Services · Le Sueur, MNN146SPSamaritan'S Purse · Boone, NCN147AGTop Gun Precision Ag LLC · Skidmore, TXN147CBJab II LLC · Mobile, ALN14837Oscar Aerial Spraying LLC · Grady, OKN148AWAircraft Trustee Services Inc Trustee · Dover, DEN148KYCommonwealth Of Kentucky · Frankfort, KY
Back to AD 2002-20-05