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.
N1714HBlue Flight II LLC · Miami, FLN1714QRoth Mark E · Stevensville, MTN1715CAerotrack Inc · Hemet, CAN1715FBradley Max T II · West Plains, MON1716CReidenbach John S · Kenosha, WIN1716RRegistration Pending · Krum, TXRegistration pendingN1716XBell Brian · Oakland, CAN17170Cannon Christopher H · Moorpark, CAN17172Tohidi Karen A · North Las Vegas, NVN17173Dunbar Michael C · Cedar Falls, IAN17174Davison Mark L · Vacaville, CAN17176Johns Thomas D · West Hills, CAN17177Dawn Patrol Flying Club · Northville, MIN1717EN2893e LLC · Reno, NVN1717VThorsness David A · Foley, MNN1717YSeventeen Yankee LLC · Fort Lauderdale, FLN17180Newby Adam M · Anchor Point, AKN17181Hays Jerry W · Heath, TXN17186Dubreuil Jean Pierre · Skyland, NCN17187Cloud Chasers Inc · Albert Lea, MNN17189Mangold Property Management Inc · Monterey, CAN1718ECaptain Kenny J LLC · Holiday, FLN1718FSavage David E · American Falls, IDN1718QRegistered aircraftN1718RStripe Joseph · Olympia, WAN1719FMoran Aviation LLC · Rose Bud, ARN1719QMartinz Mike · Big Timber, MTN171ESFenton Richard R Trustee · Mckinleyville, CAN171JSSerrato Joel · Brownsville, TXN171KSVida Vibrante LLC · San Juan, PRN171MHEvolution Solid LLC · Salem, ORN171QEndeavor West LLC · Chugiak, AKN171RJSawyer Eric O · Redding, CAN171RMMckinney Mark · Meadowview, VAN171RSSeneque USA Inc · West Palm Beach, FLN171SKHuddleston Edward · Oaktown, INN171UNancy Unicorn LLC · Seattle, WAN171VAEckles Aircraft LLC · Holdenville, OKN171WBYeager Hal J · Winterset, IAN17200Horton Andrea L · Auburn, CAN17203Ds Flight Services LLC · Battle Groun, WAN17204Estes Bruce E · Granite Bay, CAN17205International Air Services Inc Trustee · Carson City, NVN1720XKregel Brian D · Garnavillo, IAN1720ZBend Aircraft Mechanics LLC · Bend, ORN17210Babler Paul W · Blaine, MNN17218Papich William · Boston, NYN17219Daniel Boone Flying Club Inc · Boonville, MON1721CLemons Air LLC · Boulder, CON1721FCenterline Flying Club Inc · Williamstown, NJ
Back to AD 97-01-13