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.
N6097GSargester Aviation LLC · Middletown, DEN60986Kinn Folk LLC · Anchorage, AKN609FJMustang Sally Aviation LLC · Camden, SCN60SVTextron Aviation Inc · Wichita, KSN60THSims Gary R · Tucson, AZN6101JDynamic Equipment LLC · Fleming Island, FLN6105JPilonex Montana LLC · Springville, UTN610AGObr Leasing · Bristow, VAFirst renewal noticeN610DBPvr Construction LLC · Wilmington, DEN610EREmbry Riddle Aeronautical University Inc · Prescott, AZN610SPPocket Rocket LLC · San Francisco, CAN6110KJarrett Air LLC · Avon Park, FLN611ADValiair Lc Trustee · Casper, WYN611DNNelson Donald · Lavalette, WVN611EKWings Over Texas Holdings LLC · Denton, TXN611HPFlorida Highway Patrol · Tampa, FLFirst renewal noticeN611PTSierra Automation Inc · Weiser, IDN611SFWood Automotive Inc · Cropwell, ALN61237Phoenix East Aviation LLC · Daytona Beach, FLN6125PThomas Roger · Hudson, OHN612BKKqm Aviation · Manassas, VAFirst renewal noticeN612DPCarlson Glenn Alan · Byron Center, MIN612JATextron Aviation Inc · Wichita, KSN612KAGv Air Inc · Medford, ORN612PDMenagerie Enterprises Inc DBA · Denison, TXN612RWNby Productions · Bristow, VAN612XMexico Medical Missions · Missouri City, TXN6137QJeffery & Weiss Holdings LLC · Long Beach, CAN61398Ali Rizwan Rajab · Richmond, TXN613ADhs Operations LLC · Wilmington, DEN613ERTextron Aviation Inc · Wichita, KSN613ESRed Devil Aviation LLC · Aberdeen, SDN613LGRidgeline Assets LLC · Wilmington, DEN613PFGeorgia Forestry Commission · Macon, GAN613SPAirmart Inc · Lexington, KYN61422Atp Aircraft 1 LLC · Wilmington, DEN61455Hutcheson David Carl · Santa Rosa Beach, FLN6145H1100 Flournoy LLC · Alice, TXN6146AMartinez Richard Ben · Sammamish, WAN61474Harper Analeasa Leighan · Clarksville, TNN614EREmbry-Riddle Aeronautical University Inc · Prescott, AZN614FAHillsboro Aero Academy LLC · Hillsboro, ORN614KSDiy Travel LLC · Seattle, WAN614LFLunken Flight Training Center LLC · Cincinnati, OHN6152HMarcair Inc · Fort Worth, TXN615CSJerky Holdings LLC · Winter Haven, FLN615EREmbry-Riddle Aeronautical University Inc · Prescott, AZN615KEDesert & Delta Air LLC · San Francisco, CAN615SPChesapeake Skyhawks Inc · Wilmington, DEN615TWClark Jim W · Claremore, OK
Back to AD 2003-24-13