AD 97-15-01
Registered aircraft · 19,952
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-15-01')
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-15-01')
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-15-01') 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-15-01') 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.
N1069LWilson Michael A · Everett, WAN106BAnderson Martino G · Lakeland, FLN106NChenevert Eric M · Clarence, NYN106PSScarrow James D · Jerome, IDN106RGCadena Edward R Jr · Houston, TXN106UMiha LLC · Dover, DEN106VKenyon Joseph S · Fort Collins, CON10712Hall Air Inc · Weiner, ARN10714Tennessee Museum Of Aviation · Sevierville, TNN10715Noyes Stephen S · Newburyport, MAN1073MScr Aviation LLC · Austin, TXN1073QRegistration Pending · Polo, MORegistration pendingN1077B85 Alpha Inc · Wilmington, DEN1079QGriffin Marcus · Houston, TXN107SWanagel Walter · Lisbon, CTN107SPDepartment Of Emergency Svc & Public Protection · Hartford, CTN107VWHenning Nancy E · Hardinsburg, KYN107WFWilcox Farms Inc · Roy, WAN107YYBeezhold Terence J · Lake Stevens, WAN1080MFlying Particles Inc · Livermore, CAN1082PGarrett James D Jr Trustee · Coolidge, AZN1083QAhlhorn Travis W · San Marcos, TXN1084WLafayette Foundation Inc · Fort Lupton, CON1085MDuncan Terry C Trustee · Cupertino, CAN1086LLade Burton G · Bemidji, MNN1086MSargent John E · Vancouver, WAN1089MPetersen Clayton · Albert Lea, MNN108BCaturia Jeffrey T · Layton, UTN108BTFlying J Aviation LLC · Lynden, WAN108EENorthwood Services Inc · Skwentna, AKN108GBLooney Jordan · Trumann, ARN108GWPope James D · Clarkston, WAN108JHInternational Air Services Inc Trustee · Carson City, NVN108KDPayne Steven H · Nine Mile Falls, WAN108MLosey Thomas L · Ft Myers, FLN108RMFernandez Taylor R · Wasilla, AKN108SPDale County Sheriffs Office · Ozark, ALN108TTTurnbull Archie · Ypsilanti, MIN1090MBergstrom Aircraft Inc · Pasco, WAN1092WAmerican Aviation LLC · Waterville, MEN10948Morris Jacky D · Watonga, OKN109AKHarris Eric W Jr · Moncks Corner, SCN109DSBell Bradley L · Bothell, WAN109FRoos Patrick R · Purcellville, VAN109HBadke Paul J · Ray, MIN109VKeeling Rodney E · Pearce, AZN109WYPerala Daniel R · Cheyenne, WYN109YBraun Joshua S · Port Hope, MIN10ETTech Nav LLC · Columbus, INN10EVCafiero Vincent · Haskell, OK
Back to AD 97-15-01