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.
N172RWD Gordon Aviation Inc · La Jolla, CAN172SAHalbauer Peter · Hartford, WIN172SBBirmingham Flight Center LLC · Birmingham, ALN172SFTichy Joseph R · Napa, CAN172SGLehner Raymond A Jr · North Fort Myers, FLN172SKCruz Orlando R · Houston, TXN172SNBukowski Robert · Hot Springs, ARN172SPLuke Airlines LLC · Southgate, MIN172SRDiaz Robert Dorantes · Coalinga, CAN172SSWingsleasing LLC · Wichita, KSN172SXPersonal Aviation Inc · Poway, CAN172SZPowell Terry · Sheridan, WYN172TBBelli Paul · Philadelphia, TNN172TCMeweber Consulting Inc · Atlanta, MIN172TDSoule Clauson D · Cooperstown, NYN172THDairy Air Inc · Wyoming, PAN172TKRhinelander Flying Service Inc · Rhinelander, WIN172TLRegistration Pending · Katy, TXRegistration pendingN172TMTactical Integrated Training Solutions LLC · Colorado Springs, CON172TNRegistration Pending · San Antonio, TXRegistration pendingN172TPContrail Aviation Inc · Cheboygan, MIN172TRSkoglund David L · Jamul, CAN172TSVero Technical Support Inc · Pensacola, FLN172TTErvin Max W · Bend, ORN172TWGriffiths Larry F · Upland, CAN172TXD & L Innovations LLC · Hendersonville, TNN172UCEndeavour Flight Training Inc · Opa Locka, FLN172UFR&R Aero Services LLC · Eden Prairie, MNN172UZMp Aviation LLC · Ogden, UTN172VFish Air Aviation LLC · San Diego, CAN172VFVictor Foxtrot LLC · Scott City, KSN172VKKatula Gerard · Pawleys Island, SCN172VLEnce Daniel G · Saint George, UTN172VTFly Vermont LLC · Swanton, VTN172VWVanwagnen Brian J · Jackson, MIN172VYSouthern Aircraft Consultancy Inc Trustee · Casper, WYN172WLaraux Arthur · Bethel, AKN172WAHandrop Ronald S · Bonita, CAN172WBTumbleweed Leasing Company Inc · Salt Lake City, UTN172WEEl Aero Services LLC · Elko, NVN172WHSholund Stuart H · Elgin, ORN172WJBlue Skies Flight Training LLC · Gainesville, FLN172WLLeveille Wade P · Douglas, MAN172WMChaves Roosevelt Jr · Fontana, CAN172WNLegends Air Center LLC · Bentonville, ARN172WPAviair LLC · Wilmington, NCN172WRWind River Aviation LLC · Lawton, OKN172WSWoodstock Air LLC · Cincinnati, OHN172WTTison William A Jr · Boynton Beach, FLN172WVMessner Mark R · Chesapeake, OH
Back to AD 97-01-13