AD 74-18-13
Registered aircraft · 1,642
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:74-18-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:74-18-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:74-18-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:74-18-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.
N3310WBig Wing Energy LLC · Decatur, ARN3312WMcmurray Michael J · Killeen, TXN33133Balisier Aviation Inc Trustee · Wilmington, DEN33143Bascom Jon A Trustee · Tega Cay, SCN33155Don George LLC · Orlando, FLN3322WWilson Devin · Star, IDN3324WThompson Mark D · West Chicago, ILN3325WGuzman Ronald Leonard · Salinas, CAN3326WSair LLC · Natchitoches, LAN3327WBlacker James Darwin · Meridian, IDN33302Taffet Jay · New Orleans, LAN33307James Michael G · Dahlonega, GAN33324Central Nebraska Spinal Surgery Center Pc · Kearney, NEN3334PM & M Aero LLC · Wilmington, DEN33368Triple Three Six Eight LLC · Alabaster, ALN3336WBuck Brothers · Joliet, ILN3338QGreenscapes Colorado Inc · Strasburg, CON3338WQuinto Raymond Richard · Yucaipa, CAN3339WWings With The Word · Sanford, MEN333BFRoberts Christopher E · North Wilkesboro, NCN333BPSt Lucie Aviation LLC · Fort Pierce, FLN333HGLow And Slow LLC · Brookline, NHN33408Southern Aircraft Consultancy Inc Trustee · Casper, WYN33411Pumpelly Thomas H · Dayton, OHFirst renewal noticeN3342WTwo Sons Aero LLC · Wilmington, DEN3344WGracey Kenneth · Burien, WAN3348WCyrus Ely G · Kiana, AKN33496B A T S Aviation LLC · Long Island, KSN3351WRegistered aircraftN3353WGrigg Charles I Jr Trustee · Emporia, VAN3354WArocho David · Orlando, FLN33556Midwest Diesel Inc · Beemer, NEN3355WBland Joseph G · Gainesville, TXN33568Papoi Benjamin F · Phoenix, MDN3356WFive Six Whiskey LLC · Plainfield, INN3359WMcmaster James R II · Bath, PAN33631First Class Emergency Vehicles LLC · Monroe, NCN33645Conner W Larry · Los Lunas, NMN3364WOconnell Killian R · Amherst, MAN33669Ellsworth Donald · Beverly Hills, FLN3368WRegistration Pending · Bulverde, TXRegistration pendingN33694Fly LLC · Natchez, MSN33699Burris D Rob Trustee · Tucson, AZN3369WBlue Sky Aviation LLC · Attleboro, MAN3370WRaddohl Garret L · New London, MNN3374WMcfadyen Joseph P · Florence, SCN3378WKimball Jason S · Riverview, FLN3382WMoffatt Jeffrey Charles · Morgan Hill, CAN33831D&K Sales Inc · Canton, GAN3383WFour Dudes Flying LLC · Cabot, AR
Back to AD 74-18-13