AD 2017-16-11
Registered aircraft · 84,915
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:2017-16-11')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-16-11')
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:2017-16-11') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-16-11') 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.
N100CPCivil Air Patrol · Maxwell Afb, ALN100CWCoffin Craig T · Glendale, CAN100DDCook Allen J · Aurora, CON100DPEskind Thomas O Jr · Dallas, TXN100EEConcho Aviation LLC · Sterling City, TXN100ELLeading Edge Leasing LLC · Wilmington, DEN100EMKentem100 LLC · Asheboro, NCN100ENRegistration Pending · Downingtown, PARegistration pending, pending cancellationN100EUSky West Aviation Inc Trustee · Albuquerque, NMN100GDElp LLC · Bedford, NHN100GLWaco Aircraft Corp · Battle Creek, MIN100GQUsda-Aphis-Ws · Cedar City, UTN100GSPegasus Florida I Inc · San Diego, CAFirst renewal noticeN100HRSouthern Aircraft Consultancy Inc Trustee · Casper, WYN100HUSimpson Jared S · Malad City, IDN100HWYale Companies LLC · Fishers, INN100HX14 Aero Spaces LLC · Wilmington, DEN100JEResearch Consultant Solutions LLC · Miami, FLN100JGClub Cherokee Inc · Crystal, MNN100JRLumland Properties LLC · Winchester, VAN100JVKremers Gary · Zeeland, MIN100KAConservation Flight LLC · Bronx, NYN100KCMiller Byron W · Silverton, ORFirst renewal noticeN100LDPenning Jeffrey D · Clear Lake, IAN100LED&J Training Planes LLC · Logan, UTN100LFLunken Flight Training Center LLC · Cincinnati, OHN100LGFlyd Pipers Inc · Dyer, INN100LULynn University Inc · Boca Raton, FLN100LWN100lw LLC · Hickory, NCN100MSky Odyssey Aviation LLC · Gulf Breeze, FLN100MSHam Aviation LLC · Marydel, DEN100MVBensen John A · Greenville, NYN100NESanborn Map Co Inc · Colorado Springs, CON100NTBk Aviation LLC · Reno, NVN100NYAplustill Keith A · Los Osos, CAN100POut Island Magic LLC · Gainesville, FLN100PBDoobie Air LLC · Wilmington, DEN100PMPegasus Air LLC · Louisville, KYN100PTJacobs Brian E · Aptos, CAN100QRichmond Suzanne L · North Hills, CAN100QBShutt Ryan T · Eden, NYN100RFN100rf Ghost LLC · Burleson, TXN100RKEllingson Leslie B · Harwood, NDN100RTRanch 100 LLC · Fort Pierce, FLN100RVMaule Group Ltd · Wilmington, DEN100SELanger Paul Hubert · Gainesville, TXN100SVKretschman Thomas J · Verona, WIN100TOwyhee Pacific LLC · Kalispell, MTN100TCMckinney Richard P · Fayeteville, ARN100THWhiddon Mark H · Frankston, TX
Back to AD 2017-16-11