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.
N1764CRyan Michael · Gillette, WYN1764VGross John F · Winthrop, MEN1764XLeschber Larry · Hutto, TXN17651Basler Turbo Conversions LLC · Oshkosh, WIN1765FKohler Daniel J · Mapleton, ORN1765MFlying Cow LLC · Syracuse, NYN1765RPlane Pro Aviation LLC · Shelby, NCN1766MN1776m LLC · Panama City, FLN1766VCode4 Ventures Inc DBA · Waynesboro, VAN1767MAnderson Thomas C Trustee · Sun City West, AZN1767RHamel David A · Klamath Falls, ORN1768ERoyal Air Freight Inc · Waterford, MIN1768MWyoming Valley Air LLC · Old Forge, PAN1768QHarper John T · Fairfield, OHN1768VBrown Craig D · Fort Wayne, INN1768ZMoskowitz Craig B · Sheffield, MAN1769QPmn Enterprises LLC · Fremont, WIN1769RCt Aviation LLC · Waverly, NEN176EAHeath Mark R · Radisson, WIN176ERSkywarrior Flight Training LLC · Pensacola, FLN176LGTita Enterprises LLC · Apex, NCN176LLClear Above LLC · Haymarket, VAN176TCRedtail Cirrus LLC · Boise, IDN176YCessna U206f Aviation LLC · Boise, IDN1770RRegistered aircraftN1770XPark Avenue Group Inc · Stuart, FLN1771MGaley Matthew Blake · Greenwood, MSN1772FTia Aviation LLC · Hot Springs, ARN1773BBaney Robert P · Philipsburg, PAN1773FRegistration Pending · Jasper, ALRegistration pendingN1773RAsher Robert P · Oregon City, ORN1773ZMcclay David H · Lagrande, ORN1774CStol LLC · Fort Wayne, INN1774DDj Brandt LLC · Cedar City, UTN1774FBarnstormers Aero Services Inc · Lompoc, CAN1774HPeacock Bruce M · Mendon, VTN1774VAmerican Patrols Inc · Midland, TXN1775QBrooks Timothy J · Oshkosh, WIN1775RAnderson Lenny R · King Salmon, AKN1777RKnur Ronald Glen · Elizabeth City, NCN1778FBlake Brian R · Irvine, CAN1778MSeitz David C · Gordonville, TXN1778UMission Aviation Fellowship · Nampa, IDN1779MBlagg Kevin · Dumas, ARN1779ZLewis Lionel · Tacoma, WAN177AWolter Aviation LLC · Charleston, SCN177AAKnowles Mark A · Gun Barrel City, TXN177AMAdler A Michael · Bend, ORN177APThunderbird Aviation LLC · Littleton, CON177ARHull Jared Gene · Redondo Beach, CA
Back to AD 97-01-13