AD 2001-23-17
Registered aircraft · 61,706
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:2001-23-17')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-23-17')
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:2001-23-17') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-23-17') 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.
N100DSCascade Peaks Aviation LLC · Springfield, ORN100DXRegistered aircraftN100EUSky West Aviation Inc Trustee · Albuquerque, NMN100FBHoffman Swen · Sedalia, CON100FMRivkin Gerald · Saint Augustine, FLN100GFMenke Rex A · Medical Lake, WAN100GG1mk Leasing LLC · Lindale, TXN100GMHuguenard Jefferson J · Alpharetta, GAN100GSPegasus Florida I Inc · San Diego, CAFirst renewal noticeN100HDLong Trace LLC · Madison, WIN100HPHinds Community College · Raymond, MSN100HRSouthern Aircraft Consultancy Inc Trustee · Casper, WYN100HSAir Works Ltd · Wilmington, DEN100HWYale Companies LLC · Fishers, INN100JDMark Aviation LLC · Kingsport, TNN100JEResearch Consultant Solutions LLC · Miami, FLN100JGClub Cherokee Inc · Crystal, MNN100JPAviation Consulting LLC · Ada, MIN100KBExecutive Air Taxi Corp · Bismarck, NDN100KHLefevers Adam · Pineville, KYN100KJDrewyor Kenneth · Eaton Rapids, MIN100KSIndependent Aviation Consultants LLC · Sparks, GAN100KWBaldassarre Thomas Anthony · Gillette, NJN100LCozumel Leasing LLC · Wilmington, DEN100LGFlyd Pipers Inc · Dyer, INN100LKKoebele Thomas R · Cape May, NJN100LLPremiere Brand Meats · Shasta Lake, CAN100LSAg Flyers Inc · Torrington, WYN100LWN100lw LLC · Hickory, NCN100MLMl Aviation LLC · Boulder, CON100MMFarmer Aviation LLC · Milan, MIN100MRCarlson Carl J II · Aledo, TXN100MSHam Aviation LLC · Marydel, DEN100NAInternational Air Services Inc Trustee · Carson City, NVN100NKLand Air Sea Inc · Chesapeake, VAN100NNDunnair LLC · Panama City, FLN100NYAplustill Keith A · Los Osos, CAN100PFPony Express Aviation LLC · Miami Beach, FLN100PRKinder Eric Eugene Trustee · Tucson, AZN100PSG & C Property Hc LLC · San Francisco, CAN100PZAeromotors LLC · St James, MON100QTSouthwest Aviation Inc · Marshall, MNN100RABonanza Holdings Group LLC · Greenville, NCN100RBIngraham Donald S · New Bern, NCN100RESchooler Jordan Benjamin · Hummelstown, PAN100SC560 Inc Trustee · Chattanooga, TNN100SFSafe Flight Instrument LLC · White Plains, NYN100SPWright Richard S · Half Moon Bay, CAN100SXKing Samuel E · Battle Mountain, NVN100SYAerodan Aviation LLC · Alpharetta, GA
Back to AD 2001-23-17