AD 2023-17-13
Registered aircraft · 1,956
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:2023-17-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:2023-17-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:2023-17-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:2023-17-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.
N12AYYerly Alan K · Valrico, FLN12CEChazoo Air Inc · Miami, FLN12DGGrady David D · Bloomington, MNN12PAAsselta Paul M · Corinth, TXN12RTRegistration Pending · Duncan, OKRegistration pendingN12RVMurdock Michael F · Huntsville, ALN130AJVerns Aviation LLC · Port Saint Lucie, FLN130PSSpackman E Paul · Casper, WYN130TTRomero Johnny W · Houston, TXN130TVVincent Terry K · Greenville, KYN131AVAviate LLC · Hazelton, IDN1321TFluffy Bunny Flying LLC · Aliso Jiejo, CAN133LLMumford Steven · Atlanta, GAN133MLMaile-Moskowitz Anschel · Towson, MDN133RDGodfrey Kirk P · Cameron Park, CAN1345GRegistered aircraftN134ABSouthern Aircraft Consultancy Inc Trustee · Casper, WYN136AJAerjones Aviation USA LLC · Zephyrhills, FLN136RTJc/Rc Ventures LLC · Key West, FLN136TMTensfeldt Jon R · Newcastle, WAN1386YHannigan Robert V · Gifford, WAN138BAIcon Pdk LLC · Atlanta, GAN139BARegistered aircraftN139CTGrandinetti Robert L · Fayetteville, NYN139SESahni Irvin K · Seguin, TXN139SPPaul Wallner LLC · Missoula, MTN13DVMyers Matthew M · Onalaska, WAN13DZParaflight Source LLC · Prairieville, LAN140VTDetert Bradley · Valparaiso, INN141EXCirrus Aviation Inc · Sarasota, FLN141MALightbringer Aviation LLC · Flowery Branch, GAN141YRowland Richard · Hondo, TXFirst renewal noticeN1426CCavanaugh Robert F · Salem, ORN142ATRupp Tim A · Bastrop, TXN1432RScroggins Richard A · Clinton, ARN143AATorres Vincent Jimenez · Auburndale, FLN1447WRegistered aircraftN144AAPiston Aviation LLC · Saint Charles, MON144BBrownlee Elvin III · Andrews, TXN144STStar Anatoly Y · El Cajon, CAN1461FSirmon James A · Daphne, ALN1469HSinnott-Simonis Lyle · Girdwood, AKFirst renewal noticeN146BAJenkins Anthony · Henderson, NVN146CDStevens Mike · Duluth, MNN146EPLenz Christian J · Allen, TXN146UAFoale Aerospace Inc · Houston, TXN147BA1111 Vibe LLC · Dover, DEN147DKSpecialty Aerospace LLC · Grand Rapids, MIN147RTCooper Billy Paul · Columbia, MSN1488MAviation Financial Corp · Torrance, CA
Back to AD 2023-17-13