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.
N861SFAircraft Guaranty Corp Trustee · Oklahoma City, OKN862AUAuburn University · Auburn Univerity, ALN862CPN862cp LLC · Stuart, FLN862PZBuntzman Gabriel F · Bowling Green, KYN862STFoxtrot Lima Enterprises LLC · Elbridge, NYN863AUBas Part Sales LLC · Greeley, CON863DRFive Up Aviation LLC · Ambler, PAN863JANorth American Flight Services Inc · Ballston Spa, NYN863PAUniversity Of Alaska Anchorage · Anchorage, AKN863SPLegacy Aviation LLC · Tea, SDN863TCTjk Aviation LLC · New Canaan, CTN864AUAuburn University · Auburn University, ALN864CKTabatabai Seyed Ali · Houston, TXN864CPCivil Air Patrol · Maxwell Afb, ALN864SPAmeriflyers Of Texas Inc · Addison, TXFirst renewal noticeN865CKAero American Flight LLC · Houston, TXN865CPAmr Holdings LLC · Kalispell, MTN865CWSouthern Aviation · Anchorage, AKFirst renewal noticeN865DAb Prop Plane II LLC · Metairie, LAN865GWMountain West Select Inc · Ammon, IDN865JPVista Valley Aviation LLC · Ririe, IDN865PAPlatinum Angel LLC · Melbourne, FLN865TCQuinault Aviation LLC · Priest River, IDN865WMichigan Dept Of Natural Resources · Roscommon, MIN866CPCivil Air Patrol · Maxwell Afb, ALN866DMOrange County Sheriffs Office · Orlando, FLN866TTSgw Aviation LLC · Hastings, MIN867CPCivil Air Patrol · Maxwell Afb, ALN867EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN867HGTextron Aviation Inc · Wichita, KSN867LAHillsboro Aero Academy LLC · Hillsboro, ORN867MMMenzel Electric Inc · Mingo Junction, OHN868SPWestbank Fishing LLC · Kiln, MSN868TBSo Cal Leasing LLC · El Cajon, CAN868TCDlg Enterprises LLC · Iota, LAN869CPExecutive Flight Institute LLC · Murrieta, CAN869EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN869FGMustang Sally Aviation LLC · Camden, SCN86BJWings Over Texas Holdings LLC · Denton, TXN86PVPvr Construction LLC · Wilmington, DEN86RPPetree Aviation LLC · Shreveport, LAN86SKPork Chop Aviation LLC · Columbus, OHN86WEBlue Air 1 LLC · Homestead, FLN870CPAvolant Aviation LLC · Mooresville, NCN870EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN870PLake Elysian Sky Holdings LLC · Janesville, MNN870PDWings Over West Michigan Inc · Wyoming, MIN870SPEstern Kentucky University · Richmond, KYN871CPRedstone Arsenal Flying Activity · Redstone, ALN871EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FL
Back to AD 2003-24-13