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.
N29439Eagle Sky Patrol Inc · Deadwood, SDN2943AGraham Jason J · Anchorage, AKN2943CBaas Brian · Cambridge, MNN2943UHania Robert · Benicia, CAN2943XMccormack Robert · Sacramento, CAN29440Eagle Sky Patrol Inc · Deadwood, SDN29441Chan Luen Hei · Hacienda Heights, CAN29442Nance David B · Quinton, VAN29444Pikula Eric Martin · Brainerd, MNN29448Central Virginia Aviation Inc · North Dinwiddie, VAN29449Brown D W · Wasilla, AKN2944AWalker Travis J · Wasilla, AKN2944CHenry Kent · Prescott, AZN2944FJ3 Contracting Inc · Milton Freewater, ORN2944JThomas Edward R · Piney Flats, TNN2944SChartrand Robert J · Brimley, MIN2944UMillsaps David C · Tuscumbia, ALN29455Heir Richard T · Lambert, MTN29459Frana Cody R · Eagle Rock, MON2945UGriffith Ronald W Jr · Douglasville, GAN2945VMcclellan Stephanie · Hebron, ILN29462Thomas Stanley L · Thermopolis, WYN29467Teel Kevin E · Fallbrook, CAN29468Cummings Mark R · Laveen, AZN29469Gem Property Investments LLC · San Antonio, TXN2946ARuach Ministry · Dover, DEN2946CMannis Arthur · Somers, NYN2946EHigh Wing Air Services LLC · Merritt Island, FLN2946SFreed Michael · Sylmar, CAN2946UPearson Eugene L · Burns, KSN29474Leslie Jason · Dayton, OHN29479Kozminski Michael J · Caledonia, WIN2947CHess Alexander · Virginia Beach, VAN2947FCopeland Matthew S · Wichita, KSN2947JMaggio Anthony M · Harbor City, CAN29480Cobra Aviation LLC · Kalispell, MTN29481Walle Heidi N · Coarsegold, CAN29485Lily Anne Aviation LLC · Bad Axe, MIN29488Luther Charles A · Walnut Creek, CAN2948CTundra House Tailwheel Club LLC · Willow, AKN2948JSale Reported · Ruston, LASale reportedN2948YWells David · Twin Falls, IDN29495Beaudine Robert J · Westlake Village, CAN2949AEllis Sterling M · Scottsdale, AZN2949SRegistered aircraftN2949VKingdom Power And Glory LLC · Colorado Springs, CON2949YGallinat Theodore R · Milliken, CON294JSJs Jet Three LLC · Kinston, NCN29509Empty Nest Aviation LLC · Mckinney, TXN2950CHenry'S Dragline Service LLC · Winona, MN
Back to AD 97-01-13