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.
N335SPMaui Aviators LLC · Pukalani, HIN336CPCivil Air Patrol · Montgomery, ALN336MCLewis University · Romeoville, ILN337BMSky Drivers LLC · La Fayette, GAN337CPCivil Air Patrol · Maxwell Afb, ALN337CRElder Bruce W · Farmington, NMN337DBOlson Vienette · White Bear Lake, MNN337MEFlytcentrix LLC · Lewes, DEN338GSSanders Flight Training Center Inc · Jasper, ALN338MEBoulant Michael Lee Charles · Las Vegas, NVN338SAGonzalez Jesse · Colorado Springs, CON338WSWinsors Wings LLC · Rogersville, MON339MEShinkle Gordon · Gillette, WYN339SABig River Farms Inc · Natchez, MSN339SPCahill Michael · Moon Township, PAN33FMAtp Aircraft 7 LLC · Wilmington, DEN33HARykris Investments LLC · Bowling Green, KYN33LAOscar Tango LLC · Mesa, AZN340CSTextron Aviation Inc · Wichita, KSN340HPBeartooth Aviation LLC · Kalispell, MTN340MTAcron Aviation Academy Inc · Sanford, FLN341CPCivil Air Patrol · Maxwell Afb, ALN341DREcho Sierra Inc · Potomac Falls, VAN341PCWoods Ronnie Lee · Weatherford, TXN341SPSo Cal Leasing LLC · El Cajon, CAN342CSTextron Aviation Inc · Wichita, KSN342MEAerostatics LLC · Gainesville, FLN342SASunrise Aviation Inc · Ormond Beach, FLN342TSDaniels Law · Sherman Oaks, CAN343CACivil Air Patrol · Maxwell Afb, ALN343CPCivil Air Patrol · Maxwell Afb, ALN343METhurman Craig Johnson · Ona, WVN343PTDiamond Head Aviation LLC · Kunia, HIN343SASunrise Aviation Inc · Ormond Beach, FLN343SPEight16 LLC · Lewes, DEN343TCTwo Rivers Aircraft Managmenet LLC · Williamsburg, VAN344CACivil Air Patrol · Maxwell Afb, ALN344JEAlf Ix LLC · Chicago, ILN344RBContinental Aerospace Technologies Inc · Mobile, ALN344SPSun City Aviation LLC · Davie, FLN345BPeraton Services LLC · Venice, CAN345CMScherson David Alejandro · Folsom, CAN345CSFlight Training Aircraft LLC · Wilmington, DEN345DPBack Country Hacks LLC · Olalla, WAN345FHHeavy Metal Air LLC · Farmingdale, NYN345MEOtt James E · Redlands, CAN345RKButler Management LLC · Sherman Oaks, CAN345TJOpa Flys LLC · Magnolia, TXN345WCEnriquez Antonio · Austin, TXN3469246dk LLC · Ramona, CA
Back to AD 2003-24-13