AD 2003-24-13
Registered aircraft · 7,870
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:2003-24-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-24-13')
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:2003-24-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-24-13') 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.
N20505Hickin Barkley E · Kissimmee, FLN20519Skyhawk Leasing LLC · Mccordsville, INN2052GJohnson Thomas · Ballico, CAN2052VBlue Sky Personnel Services LLC · Coushatta, LAN20537Atpce LLC · Wilmington, DEN20549Atpce LLC · Wilmington, DEN2054SLewis University · Romeoville, ILN2054ZRp3 LLC · Boise, IDN2055RWnc Aviation LLC · Arden, NCN20564Atpce LLC · Wilmington, DEN20566Atpce LLC · Wilmington, DEN2057PBullock Gary · Saint Regis, MTN20597Hk Aircraft Leasing LLC · Lititz, PAN2059U5c Valley Aviation LLC · Sun Valley, IDN205FGRidgeline Assets LLC · Wilmington, DEN205HCGulf Coast Aviation LLC · New Orleans, LAN2060UJade Air LLC · Lomita, CAN2061Ramos Sammy · San Juan, PRN20617Mtnairpower LLC · Santa Barbara, CAN2061BM R O Drug Test Results LLC · Wintersville, OHN2061MN2061m LLC · Augusta, GAN2063PRegistered aircraftN2064FMicrowave Rental LLC · Beaufort, SCN2064PPrivitt Bret · Hudson Oaks, TXN206AGDesevarg Inc · Appleton, WIN206AMLiu Ke · Millburn, NJN206AZGrant Investments LLC · Bakersfield, CAN206BCSkelton Thomas N · Madison, MSN206BDBge Aviation LLC · Camden, ARN206CTextron Aviation Inc · Wichita, KSN206CCCharlie Charlie LLC · Wasilla, AKN206CPCivil Air Patrol · Maxwell Afb, ALN206CVC & C Transportation Inc · Benton, LAN206DKFly Waveboard Inc Trustee · Wilmington, DEN206DTSchons Jeffrey · Pacific City, ORN206DVBowman And Dehn Enterprises Inc · Georgetown, DEN206DWAlaskan Start Aviation LLC · Midland, TXN206DYMorgan Farms LLC · Nyssa, ORN206EAAbrams Edward L · Roxbury, CTN206EEHastings Ranch Vineyard · Paso Robles, CAN206EMHoopes Turf Farm Inc · Ulysses, PAN206ETTorgerson Eric L · Ethridge, MTN206FNFlying Neutrons LLC · Lebanon, OHN206GCCook Tyler · Seldovia, AKN206GESheldon Graham · Bellevue, WAN206HMilestone Aviation LLC · Vail, CON206HDBarry Adventure Travel Inc · Pagosa Springs, CON206HGSeecat LLC · Palo Alto, CAN206HJRauch Peter · Austin, TXN206HMDma Aviation Services LLC · Wilmington, DE
Back to AD 2003-24-13