AD 97-01-13
Registered aircraft · 54,837
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:97-01-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:97-01-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:97-01-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:97-01-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.
N310CKSt Charles Flying Service Inc · Portage Des Sioux, MON310CLSinclair Bradley W · Melbourne, FLN310CMAir Positive LLC · Selbyville, DEN310CTIcp Aviation LLC · Melbourne, ARN310DARecycled Air LLC · Hoschton, GAN310DFJordan Air Inc · Hugoton, KSN310DSWorld Marketing Syndicate I · Wilmington, DEN310EDWilson Joseph E W · Austell, GAN310EKCassel Paul · Hernando, MSN310ESDiamond P Aviation LLC · Riverton, ILN310FADenning Lawrence I · Liberty, MON310FCScott Jed L · Salem, VAN310FHDury Aviation Services Inc · De Soto, ILN310FSModi Yogini · Homestead, FLN310GGSale Reported · ObersulmSale reportedN310GJRocket City Aero LLC · Huntsville, ALN310GRDailey Jordan · Umatilla, FLN310GWM And M Aviation Leasing LLC · Wilmington, DEN310HCGlover David D · Pittsburgh, PAN310HSValiair Lc Trustee · Casper, WYN310KCMattix Charles B · Temple, TXN310LAPorter Kenneth M · Cottonwood, AZN310LBTradewind Aviation Management LLC · Oxford, GAN310LTCarrer Aviation LLC · Coshocton, OHN310LWMy Way Aviation LLC · Weston, FLN310MCEcolift Corp · San Juan, PRN310MHLawrence Jack C Jr · Saint Augustine, FLN310MLInternational Air Services Inc Trustee · Carson City, NVN310MNMid-Continental Aviation LLC · Wilmington, DEN310MSConway Completions LLC · Conway, ARN310MTEriksson James Daniel · Loudon, TNN310NDMoroney Aviation LLC · Chugiak, AKN310PERypien Andrew · Denver, NCN310PHFreeman Jet LLC · Cape Coral, FLN310PLBrooks James Milton · Pineville, KYN310QBSierra Delta Aviation Services Inc · Middletown, DEN310QDHowell Charles N Jr · Cordova, TNN310RSky King Airplanes LLC · Lewes, DEN310RCFuchs Rolf G · Tavernier, FLN310RDSouthern Illinois University Board Of Trustee · Murphysboro, ILN310RMKeeton Andrew · Palestine, TXN310RRWateractive43 LLC · Auburn, CAN310SFGear Down Aviation LLC · Boynton Beach, FLN310SL336 Investments LLC · Sumrall, MSN310STWorld Pilot Services LLC · Garland, TXN310SVFlairships LLC · Durham, NCN310TAW Ne Holdings LLC · Harrisburg, NEN310TCWalton Mark · Martinsburg, PAN310TJRegent Trust Corp Trustee · Wichita, KSN310TLRegistered aircraft
Back to AD 97-01-13