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.
N1506YVaughn Jeffery Page · Shenandoah, VAN1507EGonzalez Moya Camilo Rafael · Fort Worth, TXN1507QSafety In Motion Flight Center Inc · Puyallup, WAN1508CHutchings Alan J · Clewiston, FLN1508FHaley Wayne C · Okeechobee, FLN1509CHammerquist Blake T · Benicia, CAN1509MChalk 2 Inc · Apple Valley, CAN1509QBeavers David · Strasburg, CON150AJChristianson Alan J · Washougal, WAN150AKCamp Ted A · Williamson, GAN150ANBachman Aviation LLC · Independence, IAN150ARBerry Norman R · Knoxville, TNN150AWJohnson Seth · Gulfport, MSN150AYLegacy Aviation Foundation Inc · Staten Island, NYN150BGMbw Aviation LLC · Bay City, MIN150BKTribec Inc · Medina, OHN150BNHernandez Ralph · San Antonio, TXN150BPRiffle Christopher Thomas · Charleston, SCN150BWRollinson Mark H · South CanterburyN150CPrincess North Inc · Lindstrom, MNN150CEBrazier Glen A · Greenbush, MNN150CFDesutter S Bryan · Manito, ILN150CGRomano Brian P · Terryville, CTN150CJMorrell John I · Seymour, TNN150CMDunn James W · Otis, MEN150CQCalarco Richard A · Hillsboro, ORN150CVMmdt Aero LLC · Worthington, OHN150DBEvans Thomas J · Little Elm, TXN150DDFuentes Daniel · Coral Springs, FLN150DECopaair Maintenance Services Inc · Indiantown, FLN150DFTaildragger Hq LLC · Melrose, FLN150DKShipe Jacqueline M · Louisville, TNN150DLLedford Joseph Daniel · Cedartown, GAN150DPVendetti Michael J · Olney, MDN150DSShelbyville Central High School Cte · Shelbyville, TNN150DTWatson Matthew L · Liberty, UTN150ETjelta Peter A · Sheyenne, NDN150EBRegistered aircraftN150EGGreene Harry L · Waipahu, HIN150EHPouya Hamid · San Jose, CAN150EMArman Michael P · Oak Hill, FLN150EQSmart Aviation Solutions Inc · Lakeland, FLN150EWGlazier Matthew S · Presque Isle, MEN150FFKelly Paul M · Granite Bay, CAN150FJSale Reported · Crystal, MNSale reportedN150FLBerry Jeffrey Thomas · Clovis, CAN150FMSanders Steven M · Powell, WYN150FSCustom Air International LLC · Homestead, FLN150FTLevine Albert E · Bloomfield, CTN150GNCarr Greg Wayne · Mccloud, CA
Back to AD 97-01-13