AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N25030Eller Walton G III · Katy, TXN2503DAlnico Aviation LLC · Lafayette, INN2504BHatz Aeronautics LLC · Pompano Beach, FLN25055Dakota N25055 LLC · Irvine, CAN25059West William Douglas · Newton, NCN2505RTcheutchua Romeo J · Olathe, KSN2505ZStratton Robert Stephen · Boulder, COFirst renewal noticeN2506WHeiss William R · Watkins, CON2507Wagar Dennis Murphy · Marion, MTN2507QGift Arthur D Trustee · Wanatah, INN2507TCoscarelli Guillrtmo H · Wailuku, HIN2507WHoffman Ray Y · Elysburg, PARegistration revokedN2508WBas Part Sales LLC · Greeley, CON25096Green Air LLC · Novato, CAN2509RStovall Shane R · Salado, TXN2509XOrsippus Management LLC · El Dorado Hills, CAN2509ZKovach Kim A · Ocala, FLN250AKDb Aviation Holdings Group LLC · Fort Lauderdale, FLN250AUPeregrine Howard Partners II Lp · New Orleans, LAN250BASouthern Cub & Aircraft Restoration LLC · Pensacola, FLN250BDSalom Auguste G · Old Orchard Beach, MEN250BTHeart Gate Enterprises LLC · Pittsburgh, PAN250CCAerodynamics Worldwide Inc · Wilmington, DEN250CRTruflight Leasing LLC · Owasso, OKN250DJRhoades James H · Pleasanton, CAN250ESilver Creek Aviation Services · Fort Worth, TXN250FDTailwind Aviation Inc · Sault Sainte Marie, MIN250FMParagon Airplane Leasng Co · Fort Myers, FLN250GTComanche Golf Tango LLC · Clifton, VAN250HCCornerstone Air Holdings LLC · Fort Scott, KSN250JFSnapp Michael D · Portland, ORN250JGGross Jeffrey M · Bastrop, TXN250LMenefee Scott A · Los Banos, CAN250LJCarew Aviation Inc · Appleton, WIN250LSIszak Lenard A · Palm City, FLN250MPray Aviation Inc · Augusta, KSN250MALc Flyers LLC · Monument, ORN250MDInternational Air Services Inc Trustee · Carson City, NVN250MELake Superior Aviation Llp · Duluth, MNN250MGAkin Kent Trustee · Midland, TXN250MPJohanson Jason · Groveland, CAN250PCHerndon Timothy M · Kingston, OKN250RBWestern Slope Aviators LLC · Delta, CON250RTMatthews Aviation LLC · Hardinsburg, KYN250SBInternational Air Services Inc Trustee · Carson City, NVN250SPInternational Air Services Inc Trustee · Carson City, NVN250SUOklahoma State University · Stillwater, OKN250TASunset Aviation LLC · Halifax, PAN250TJTalley John T · Clifton, TXN250WAWelch Eric · Lakeland, TN
Back to AD 2006-10-21