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.
N2108LSoutheast Aircraft Leasing LLC · Jacksonville, FLN2108ZPinnacle Aviation Services Inc · Encinitas, CAN2109JRaf Ks LLC · Wichita, KSN2109LCaban-Loperena Jumil · Moca, PRN210BCDurant Bruno Gerard · Coalmont, TNN210HFHeritage Asset Leasing LLC · Ronkonkoma, NYN210SUOhio State University · Columbus, OHN21147Woolf Sarah Clark · Fresno, CAN2114QJet Air Inc · Iowa City, IAN2114RPower Michael L · Bend, ORN2114UBravo Zulu Aviation LLC · Torrance, CAN2115KLiprie Randal C · Lake Charles, LAN21180L&W Leasing LLC · Murfreesboro, TNN2118ASouth Dakota Highway Patrol · Pierre, SDN2118JLamb Chops Inc · Bakersfield, CAN2118LIasco Flight Training Inc · Redding, CAN21198Jackie Hood Farms LLC · Moulton, ALN2119EMid-Island Air Service Inc · Ronkonkoma, NYN2119QMustang Sally Aviation LLC · Camden, SCN211FJFox Point Airways LLC · Sheridan, WYN211FTUniversity Of The South · Sewanee, TNN211GTB & B Crane Service LLC · North Myrtle Beach, SCN211MRPowerbelt LLC · Glendale, CAN211TDChristiansen Aviation LLC · Wilmington, DEN21200Paramus Flying Club Inc · Fairfield, NJN21212Sale Reported · Phoenix, AZSale reported, canceledN2121FSouth Dakota State University · Brookings, SDN2121XTaylor Commercial Properties LLC · Jackson, TNN2122MHalsted Aviation LLC · West Chicago, ILN2122ZObrien Air LLC · Prescott, AZN2123EDream Flights LLC · Brewton, ALN2123YPalin Investments 3 LLC · Vancouver, WAN2125ACable Thomas G · Rockford, MIN2125MNfh Aviation LLC · Pikeville, KYN21263Suburban Air Corp · Castro Valley, CAN2126FVista Aviation Inc · Pacoima, CAN21276Schrager Daniel L Trustee · Concord, MAN2128YE-Cubed Industries LLC · Big Piney, WYN2129CFlot Group LLC · Apex, NCN2129JRidgeline Assets LLC · Wilmington, DEN212BSEuros Aircraft Leasing LLC · College Station, TXN212CFWest Coast Equipment Leasing LLC · Englewood, CON212FSTrinity River Lumber Co · Weaverville, CAN212ZSkies The Limit LLC · Fuquay Varina, NCN2130FSilverhawk Aviation Academy LLC · Caldwell, IDN2131ATru Flight Materials LLC · Wilmington, DEN2131UAgh Property Investments Inc · Key West, FLN21326Ttf Flying LLC · Anderson, SCN2132WWheeler Equipment Leasing LLC · Gainesville, GAN21331J-Air Eagle LLC · San Antonio, TX
Back to AD 2003-24-13