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.
N2705LLt Aviation LLC · Plattsmouth, NEN2705QAdkins Emily L · Statesville, NCN2705SCarter James E · Thornville, OHN2705XShallow David M · Salmon, IDN2706AFlhs LLC · Cedar Park, TXN2706GBlack Deberah L Trustee · Las Vegas, NVN2706SWings With The Word · Sanford, MEN2706TDodson Internarional Parts Inc · Rantoul, KSN2706UHoelsch Shawn C · Livermore, CAN2706VBeuschel Timothy W · Mount Pleasant, WIN2707FMontgomery Robert · Casper, WYN2707GFluckey Gary T · Homer, AKN2707UHills Holding · Newark, DEN2708LRafter Jm Enterprises LLC · Swink, OKN2708QElkhorn Aviation Inc DBA · Baker City, ORN2708SQuiroga Herman R · Phoenix, AZN2708TCae Aviation LLC · Peshtigo, WIN2708YWings Aircraft LLC · New Richmond, WIN2709BA&R Investments Inc · Sylvania, OHN2709FArmentrout Billy W · Thomasville, NCN2709LGuideair LLC · Eden Prairie, MNN2709RSchultz Daniel A · Tipp City, OHN2709XCmvii LLC · Chugiak, AKN270ATsg Associates LLC · Stanley, NCN270AMCode 1 Flight Training LLC · Wills Point, TXN270CLRegistration Pending · Chesterfield, MORegistration pendingN270HSTextron Aviation Inc · Wichita, KSN270KCLeyva Kevin S · Wilbur, WAN270RCEagle 1-N270rc LLC · San Juan, PRN270SVJones Joseph D · Broken Arrow, OKN2710JPeople Incorporated Of Virginia · Abingdon, VAN2710UCape Aerial Tours DBA · Chatham, MAN2710XReinhart Richard A · Cook, MNN2711GAlexander Marshall J · Klamath Falls, ORN2711NMountain Air Aviation LLC · Fruit Heights, UTN2712FDodson International Parts Inc · Rantoul, KSN2712QGrotbeck Carter L · Albuquerque, NMN2712SKelly Matthew Raymond · New Florence, MON2713GPalmer Carroll W · Harper, ORN2713LFlemmer Richard W · Park City, MTN2713QJeff Jones Aircraft Company LLC · Quincy, WAN2713UAeronetica LLC · Tulsa, OKN2714FDdh LLC · Goddard, KSN2714GRegistered aircraftN2714JRegistered aircraftN2715FLow Wings Aviation LLC · Gassville, ARN2715LGoebel Christian E · Luray, VAN2715TDelaware Aircraft Trust LLC Trustee · New Castle, DEN2715UBelle Fourche Flight Center LLC · Belle Fourche, SDN2716SWright Herbert L · Vickery, OH
Back to AD 97-01-13