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.
N2037GMerryweather Clair T · Alpine, UTN2037RVertical Ascent LLC · Breckenridge, CON2037XDavis Russell C · Greenbrae, CAN2037YArgos Retail LLC · Mcallen, TXN20381Dsr-Cherokee 180 LLC · Dallas, TXN20382Bass Philip D · Oviedo, FLN20384Rutherford Jeffrey L · Montgomery, ALN20387Bybee Mark J · De Soto, ILN20389Kcn Aero Club Inc · Overland Park, KSN2038EStevens Michael J Jr · Humble, TXN2038RScaturro Timothy P · Lakewood, CON20390Mitiguy Aviation LLC · Stow, MAN20392Registration Pending · Miami, FLRegistration pending, pending cancellationN20393Nextgen Flying LLC · Pigeon Forge, TNN20394Eller Ralph E · Wasilla, AKN20398Laron W Hall · Hurricane, UTN20399Total Flight Aircraft Leasing LLC · Apex, NCN2039RChurch Of The Word International Inc · East Earl, PAN2039ZBradberry Charles G · Iowa Park, TXN203AKHornyak Ryan J · Girard, PAN203BNCarlson Curt · Lake Havasu City, AZN203EPAlvarez Bernardo · Clayton PanamaNon-citizen corporation, flight hours not reportedN203GTUniversity Of Michigan Flyers Inc · Ann Arbor, MIN203JLJfra LLC · Miami, FLN20402Fosdick Kenneth E · Plymouth, MAN20403Deatherage Edward D · Salina, KSN20404Air Data Solutions LLC · Natchitoches, LAN20405Buffalo Wings LLC · Overland Park, KSN20406Sp Airparts LLC · Moscow, IDN2040REco Flite Service Inc · Lake Elsinore, CAN2040XBas Part Sales LLC · Greeley, CON2040ZCreech Daniel B · Chewelah, WAN20410Widjokongko Antonius · League City, TXN20413Colton Terence J · Point Roberts, WAN20418Pierce Scott W · Fredonia, NYN2041GSmith Stacey · Malakoff, TXN2041QGarcia Cameron A · Yukon, OKN20420N83993 LLC · Cherry Hill, NJN20421West Michigan Flying Club Inc · Norton Shores, MIN20423Lowcountry Flight LLC · Johns Island, SCN20427Sleight Craig R · Prineville, ORN2042QKachemak Bay Flying Service Inc · Temple, TXN2042RJanssen David W · Ault, CON2042ZNedoba John · Stevensville, MIN20431Organization Of Black Aerospace Professionals · Westchester, ILN20437Wingsleasing LLC · Wichita, KSN20439Wilken Virginia · Sequim, WAN2043QAnderson Michael R · Bedford, INN2043YGrierson Robert A · Queen Creek, AZN2043ZRobotico Holdings Corp · Roselle, IL
Back to AD 97-01-13