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.
N17FCUsda Forest Service Fepp · Columbia, SCN17FGWard Bruce L · Key West, FLN17GNGrant Aviation Inc · Anchorage, AKN17GWSalus Aviation LLC · Jupiter, FLN17HLRiley Charles S · Littleton, CON17HSRed Oak Centurion LLC · Red Oak, IAN17HZLeading Edge Flight Academy LLC · Bend, ORN17JYYorkavitz James B · Valley City, OHN17MHEcho Aviation LLC · Verona, WIN17MMBekanich Jason · Camden, NCN17NFBravo Hotel LLC · Lewes, DEN17NJCivil Air Patrol Inc · Maxwell Afb, ALN17NWEye Clinic Building Lllp · Bismarck, NDN17RRRiverside Flight Center Inc · Tulsa, OKN17SMN17sm LLC · Coral Springs, FLN17SRNcsb LLC · Anchorage, AKN17TBarney Julius C · Lutz, FLN17TCKenyon Walter C · Eureka Springs, ARN17UPRhinelander Flying Service Inc · Rhinelander, WIN180Moore James M · Grass Valley, CAN18004Hause James H · Negley, OHN18006Lockhart Curtis M · Bay Village, OHN1800FReid Brian M · Boise, IDN1800QNiswander Richard A · Upton, KYN1800RSugrue Aviation Inc · Silver City, SDN1800XValentine Edward Lawson · Dallas, TXFirst renewal noticeN18015Little Bird 150 LLC · Lake Tapps, WAN1801XClark Curtis S · New Carlisle, OHN1801ZGould Robert R Jr · Sterling, VAN1802Long Randy B · Coleman, TXN18020N18020 LLC · Chandler, AZN18021Tilden Jeffrey D · Columbus, INN18023Remain In The Pattern LLC · Meridian, IDN18025Evans II Rodney D · Saint Albans, WVN18026Registered aircraftN1802FSantiago Ferdinand · Calhoun, GAN1802RMontaska Management Inc · Anchorage, AKN1802VWard Robert L Jr · Cleburne, TXN1802ZSparks Timothy J · Jackson, MIN18032Old School Aircraft LLC · Jackson, TNN18033Barkley John · Austin, TXN18038Overton Asset Group LLC · St Marys, IAN1803MWhitfield Edward · Mcpherson, KSN1803YOfficial Stripes LLC · New Braunfels, TXN18042Carey Daniel F · Rockville Centre, NYN18046Beavers David A · Strasburg, CON1804FWaage Todd · Greenbush, MNN1804VBuskas Blake Rodney · Whitefish, MTN1804YSnader Douglas E · West Linn, ORN1805Mcgarry Patrick L · Payson, AZ
Back to AD 97-01-13