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.
N2237GSmith Caleb · Beggs, OKN2237JSudduth Mark E · Lancaster, PAN22385Knutson Wayne R · Thompson, NDN2238CGorham Wendy J · Grand Rapids, MNN2238EAtd Pilot Training LLC · Kansas City, MON2238JPearce William · Grants Pass, ORN2238XStyron Mark A · Pasadena, TXN2238YFerrara Edmond · La Puente, CAN22395Morrison Donald D · Santa Clarita, CAN22396Jordan Lennon D · Bartow, FLN2239GPotter Cleve J · Fresno, CAN223BDN223bd LLC · Fresno, CAN223BECampbell Edward A · Anchorage, AKN223BTMull David L · Kathleen, GAN223KHAirprop Inc · Portsmouth, NHN223LDGaston'S White River Resort Inc · Lakeview, ARN223PBHyannis Air Service Inc · Hyannis, MAN223RJCline Larry J · Beeville, TXN223SCSurdex Corp · Chesterfield, MON223TLZanghi Michael · Katy, TXN223TRTurner Lee W · Valdosta, GAN223WHPerrin James F · Bancroft, WIN22401Knotek Larry A · Reno, NVN22409Tanner David A · Onalaska, TXN2240EKellogg Jeffrey D · Adams Center, NYN2240JBreithaupt Tracy L · Alexandria, LAFirst renewal noticeN2240XTri-Rotor Spray & Chemical · Ulysses, KSN22415Viking Wings LLC · Kindred, NDN2241SEdmondson James K · Lemoore, CAN2241TWhittock Tyson H · Anchorage, AKN22429Johnson Dustin W · Puyallup, WAN2242GNelson Mark · Fairbanks, AKN22435Pearson Charles C · Covington, LAN22436Pecht Scott A · Reedsville, PAN22439Birginia Aviation LLC · Forest, VAN2243CBelleville Livestock Market Inc · Belleville, PAN2243EFord William H · Downers Grove, ILN2243XSmith Debra A · Louisville, KYN2243YReeves Adrianna M · New Carlisle, INN22448Eddy Lisa M · Benton, KSN2244CSkywagon Aero LLC · Wilmington, DEN2244TAmerican Elevator · Ruidoso, NMN2244XPlane Life LLC · Wilmington, DEN2244YHaberer Mark M · Elbow Lake, MNN22452Waddy Bertha L · Villa Ridge, ILN2245CChesnut Lonnie R · Palmer, AKN2245GSkyair Express LLC · Overton, NVN2245JRiver City Aviation LLC · Carmichael, CAN22462Organ Daniel W · Vernonia, ORN2246ELauer Richard D · Mount Laurel, NJ
Back to AD 97-01-13