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.
N2862UWallace Jon W · Ozark, ARN2862XMathews Nancy M · Englewood, TNN2862YDickson Troy S · Placerville, CAN2863ASkipper Jonathan H · Fayetteville, GAN2863EWetherley Aviation LLC · Boise, IDN2863FWright William J · Raeford, NCN2863QSalsbery Randall E · Sharpsville, INN2863YPiontek Claudia A · Henderson, NVN2864FPreszler Sharon J · Mesa, AZN2864LTakle Management LLC · Bethany, OKN2864QEaglet Flight Operations Lp · Fort Worth, TXN2864STop Aircraft Leasing LLC · Wilmington, DEN2864XCardinal Airways LLC · St Johns, FLN2865FMctaggart Briar · Oroville, CAN2865LIfr LLC · Springfield, MON2865QLasalle Charles H · Williamstown, NYN2865YSinclair Maurice A · Melrose, IAFirst renewal noticeN2866ATruman Sparks Aviation LLC · Snyder, TXN2866FHowell Thomas F · Red Bluff, CAN2866KDobransky Robert J · Peoria, AZN2866LRegistration Pending · Spring Branch, TXRegistration pendingN2866QAircraft & Aviation Professionals LLC · Coldwater, MIN2866VLyles Ed · Newnan, GAN2866XFeller Gerald A · Long Beach, CAN2867SJarrell Loyd F · Whitesburg, TNN2867XThrush Air Lc · Mason City, IAN2867YCook Kevin M · Hallettsville, TXN2868ATaylor Eric C · Port Townsend, WAN2868FKilduff Transportation LLC · New River, AZN2868KMyers Mark D · Anchorage, AKN2868QRutherford Services Inc · Plains, PAN2869LHelmstetler John D · Mt Vernon, TXN2869QDurnall Daniel J · Sonora, CAN2869RDiehl Steven L · Martinsburg, PAN2869UDavis Isabelle L · Mason, NHN2869YDurand Russell Gene · Luthersville, GAN286ATN286at LLC · California, MDN286PMPlanemasters Ltd · West Chicago, ILN2870UKline Kevin J · Clyde, OHN2870YDabevv LLC · Salina, UTN2871KPace Robert A Jr · Pensacola, FLN2871RBlue Ridge Flyers Inc · Leesburg, VAN2871USt Clair Dustin W · Cloverdale, CAN2871YJohnson Cynthia Trustee · Sagle, IDN2872AArdmore Aviation LLC · Russell Twp, OHN2872KR N Geraci LLC · Lutz, FLN2872QTriad Aviation Academy LLC · Greensboro, NCN2872VRamirez Jose · Altadena, CAN2873AAndelin Sheila P · Newport Beach, CAN2873QCloud Dancer Aviation Inc · Deland, FL
Back to AD 97-01-13