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.
N2658FClayton Alfred T · Anchorage, AKN2658GSauer Roger A · Glenburn, NDN2658JLife Finds A Way LLC · Sarasota, FLN2658RNorthern Science Services LLC · Anchorage, AKN2658ZVirtue Genetics LLC · Cedar Rapids, IAN26595Levy Alfred E · Richardson, TXN2659GMarmon David J · Great Falls, MTN2659KWickline Wayne · Flower Mound, TXN2659QMorrison Mark C · Marfa, TXN2659RBerrios Antonio · Genoa, ILN2659SRovey Gerald A · Troy, IDN2659ZWings Over Texas Holdings LLC · Denton, TXN265DTLynn Daniel K · Beaverton, ORN265ERAerosolutions Group Inc · Wilmington, DEN265HPN265hp LLC · Parachute, CON265KPKalinin Partners LLC · Juneau, AKN265PCSilver Eagle II LLC · Carson City, NVN265RGHerron Aviation Group LLC · Dexter, MIN2660Applegate Land Holdings LLC · Jacksonville, ORN26601Trowbridge Rodney L · Haysville, KSN2660FWheels Up Aviation Inc · Lewes, DEN2660GFruge Cory · Egan, LAN2660RPa Bo Ma Inc · Alexandria, LAN2660UUnited Front Holdings LLC · Laguna Hills, CAN2660YRam Aviation LLC · Palmer, AKN2661ABerry Scott F · Destin, FLN2661LHall David B Jr · Midland City, ALN2661QAlred Robert I · Barrow, AKN2661UMoret Ronald P · Los Osos, CAN2661YAlaska Outdoor Consultants LLC · King Salmon, AKN2662GWhitman Monty · Pagosa Springs, CON2662JHanel Bruce · Placerville, CAN2662LWaller Leslie P · Cynthiana, KYN2662UDeal Sarah M · Saint Joseph, MIN2662VPeck Kim O · Bolton, MAN2663QBerg Weston L · Stanton, NDN2663SMaclean Kenneth J · Northborough, MAN2663UBas Part Sales LLC · Greeley, CON2664FWisconsin Aviation Inc · Watertown, WIN2664LAce Airways LLC · Quincy, WAN2664SMcclain Daniel S · Enon Valley, PAN2664VKeaveny Kelly J · Annandale, MNN2665CWindsock Skies LLC · Caldwell, TXN2665LKay Bennie L · Brigham City, UTN2666DDrda Enterprises LLC · Denver, CON2666GForward Logistics LLC · New Castle, VAN2666JA-Leasing · Dayton, OHN2666QCloos Randy J · Osburne, IDN2666SHageness Hartley · Rugby, NDN2666URegistration Pending · Decatur, TXRegistration pending
Back to AD 97-01-13