AD 95-26-13
Registered aircraft · 21,464
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:95-26-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:95-26-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:95-26-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:95-26-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.
N121AVPreece William F · Cheshire, CTN121DBTexins Flying Club · Mckinney, TXN121ESWell Bilt Industries USA LLC · Ocala, FLN121FTBowman William K · Raleigh, NCN121GHSunset Aviation LLC · Huntington, INN121HEJarrett Air LLC · Ashland City, TNN121JTEffingham Eta LLC · Effingham, ILN121LMGolden Age N121lm LLC · Des Moines, IAN121MDBaggarly Michael · Newnan, GAN121SClark William H IV · Thurmont, MDN121TCDonney Tom J · Sturgis, SDN121TFTorres Juan · Modesto, CAN121TWBlue Ridge Mountain Flyers Aviation LLC · Mineral Bluff, GAN1222TPraniewicz Charles P · New Kensington, PAN1224TAig Aeronautics LLC · Guaynabo, PRN1226TLinde Glenn F Jr · Juneau, WIN1227TStieper David Paul · Forest Lake, MNN1228REcko Air LLC · Springfield, MON122HSMarbury Sherri E · Jackson, TNN122KTRustair Inc · Anchorage, AKN122MCShouk Aviation LLC · Waverly, OHN122NAGilded Gull Aviation LLC · Middletown, RIN122TEBouchillon James R · Hanahan, SCN1230UPiper Aircraft Inc · Vero Beach, FLN1232TAlexander Charles W · Slidell, LAN12347Butler Construction Services LLC · Oak Grove, MON12354Spencer Christopher · Voorheesville, NYN1235SBarney Erick L · Jacksonville, ORN1236TOtero Edgardo A · Tucson, AZN1237HGivens Timothy A · Collierville, TNN1239PPinellas Pilots Association Inc · Clearwater, FLN123AXSouthern Aircraft Consultancy Inc Trustee · Casper, WYN123BEBald Moutain Aviators · Fredericktown, MON123CMSweet Wings Inc · Bethlehem, PAN123DUInternational Air Services Inc Trustee · Carson City, NVN123GCParsons John · Winter Park, FLN123GEFlying Four Inc · Saint Petersburg, FLN123GKKolis George J · Pennsauken, NJN123JCDippolito Mario M · Sherwood, ARN123KCHelms Brandon M · Indian Trail, NCN123KRRuhlin Thomas J · Lakewood Ranch, FLN123LUSutton Aircraft Salvage LLC · Palmer, AKN123MFAronhalt Daniel E · Columbus, INN123SWBelschner Custom Meats · Amherst, NEN123TXGofly Corporation · Port Ewen, NYN123UASchlabach Sharon · Lakewood Rch, FLN123YAAircraft Guaranty Corp Trustee · Oklahoma City, OKN1241TGale Richmond T · Tewksbury, MAN1242HKaliebe Kyle D · Mount Pleasant, WIN1242TDoblmaier Thomas J · North Wales, PA
Back to AD 95-26-13