AD 99-05-13 R1 WD
Registered aircraft · 13,518
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:99-05-13-R1-WD')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
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:99-05-13-R1-WD') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD') 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.
N3002WRio Concho Aviation Inc · Weatherford, TXN3005CFodor Vincent A · Doylestown, OHN3008CTech Aero Avionics LLC · Denton, TXN300ABDelaware Aircraft Trust LLC Trustee · New Castle, DEN300BMohave Maverick Aviation LLC · Bullhead City, AZN300CLHustak Michael G · Granbury, TXN300JLKehoe Keith J · Marion, TXN300JNK-M Air Enterprises Inc · Corona, CAN300JRBeechcraft Heritage Museum · Tullahoma, TNN300KKrakeel James A · Mount Pleasant, SCN300MSChua Johann L · Daly City, CAN300NEBoone Steven E · Harrison, TNN300RSLane Tyrone · El Dorado Hills, CAN300RTChoux Aviation LLC · Cypress, CAN300SAWhalen Sean B · Naples, FLN300TTDg Aero LLC · Little Rock, ARN3012CHealy David Paul · Arlington, TXN3012HBonanza Two USA Inc Trustee · Wilmington, DEN3014WRunyan Joseph D · Bushnell, ILN3015CSorna Douglas J · Flower Mound, TXN3015WDl321 LLC · Lavon, TXN3016CMoore Todd M · Peoria, ILN3017WKirk Michael E · Alvin, TXN3018SPerez Daniel · Pembroke Pines, FLN3018WAerosport Aviation LLC · Laredo, TXN301JFGrace Eric C · Valdosta, GAN3020CBrosnan Daniel · Mary Esther, FLN3021WElliott Robert · Hartington, NEN3023WBoughen James R · Camas, WAN3024HMll Air LLC · Kalispell, MTN3024QJones Sean D · Adams, TNN3027CPelayo Fernando · La Puente, CAN30282Saucerman Equipment Leasing LLC · Indianapolis, INFirst renewal noticeN3028WK2 Aviation LLC · Carroll, IAN3029CHeyneman John M · Sheridan, WYN302BCG2 Leasing LLC · Cedar Spring, MIN302WDivine John S III DBA · Myrtle Beach, SCN3030DBoardwalk Management LLC · Kalispell, MTN3030SBrewer Mike · Cameron Park, CAN30315Registered aircraftN3031QBrut N3031q · Los Angeles, CAFirst renewal noticeN3032CPrice Michael J · Pulaski, NYN3032LBlue Sky Air Ventures LLC · Wilmington, DEN3032WDebrouwer Isabelle Mc · Alpine, TXN3033CMetzger James R · Payette, IDN3034CTyler Bonnie Flying LLC · Tyler, TXN3035WWorldwide Air & Sea Inc · Wilton, NHN3036CSimpkins Larry D · Williamson, WVN3036WSpowart James F DBA · Huntington Beach, CAN3039CDammel Stanley J · Odessa, WA
Back to AD 99-05-13 R1 WD