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.
N2328YRogue Air LLC · Miller, SDN23290Walker Jeffrey · Warwick, NYN23291Oracle Aviation LLC · Omaha, NEN23295Cook Erik C · Redmond, ORN23299King Keith L · Lexington Park, MDN2329EMeshoppen Air LLC · Meshoppen, PAN2329FFlorida Aeronautical Survey Technologies · Fort Lauderdale, FLN2329GRegistration Pending · Eagle River, AKRegistration pendingN2329RRivers Andrew · Midland Park, NJN232BTHnw Aviation LLC · Melbourne, ARN232CBLight Air Development LLC · Helena, MTN232DTChancellor Shares LLC · Liberal, KSN232LSElliott Arthur M · Portland, TXN232MTAir Force Life Cycle Management Center · Lexington, MAN232RSWright Aviation LLC · Lawton, OKN233Stone Scott Robert · New Waverly, TXN23302Adams John C · Gladstone, MON23303Chuzy Suzy LLC · Lafayette, LAN23304Gendy Shady S · Columbia, PAN23305Fuhrmann Brandon R · Aberdeen, SDN23308Hotel Bravo Aviation LLC · Sumrall, MSN2330EManhattan Flying Tigers Inc · Bozeman, MTN2330GEmshwiller Mark E · Camp Verde, AZN2330JWilliamsburg Air Service Inc · Kingstree, SCN2330XKeller Ronald B · Bosque Farms, NMN23311Sweeney Daniel W · Broad Brook, CTN2331FReeves Thomas W · Issaquah, WAN2331GSouth Bay Aviation Inc · Torrance, CAN2331RSawicki Michael T · Midland, MIN2331SMiller Randy L · Enid, OKN23322Lopez William Alberto · Miami, FLN23323Boccaccio Peter Anthony · Burke, SDN23324Walden James F · Willcox, AZN23328Scmitt Rudy · Brookshire, TXN23329Welles Richard V · Elmira, NYN2332CBalgoyen James T · Charlotte, MIN2332EMelbourne Flight Training LLC · Melbourne, FLN2332SLouisiana Military Museum · Abbeville, LAN2332YAlbi Aero LLC · Denver, CON23330N23330 LLC · Bedford, PAN23333Leading Edge Aviation LLC · Lewiston, IDN23337Mosquito LLC · Chesaning, MIN2333CAfs Inc · Grants Pass, ORN2333GRegistration Pending · Belen, NMRegistration pendingN2333KAircraft Guaranty Corp Trustee · Oklahoma City, OKN2333XHjr Aviation LLC · Reno, NVN2333YSkillman Flying Services LLC · Brookshire, TXN23344Hmh Consolidated LLC · Lake Placid, FLN23348Noel Tom W · Galloway, OHN23349Fairwinds Aviation LLC · Goldsboro, NC
Back to AD 97-01-13