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.
N25ZZ25zz LLC · Abilene, TXN2600FZorrilla Peter · Charles Town, WVN2600GBad Company Aviation LLC · Peachtree Corners, GAN2600LN2600l LLC · Pageland, SCN2600QBivens Jason D · Duncan, OKN2600ROrlandella Vito P · Auberry, CAN2600YCurrin Thomas E · Pendleton, ORN2601FFly3h4 LLC · Hillsboro, NDN2601LCobb William J · Cincinnatus, NYN2601UK D Helicopters Inc · Shingleton, MIN2602GConran Joshua · Belmont, MIN2602RSiegel Jeffrey P · Snowmass Village, CON2602UVan Zee Charles C · Rancho Cucamonga, CAN2603Intentus Aviation LLC · Sunset, TXN2603FHolloway Graham · Orcutt, CAN2603KPadilla Management Inc · Burlington, WAN2603LMagel David J · Lakemoor, ILN2603RHopper Jeremy G · Amity, ORN2604GBlessing Christopher B · Houston, DEN2604SGillespie Dan L · Discovery Bay, CAN2604UTalboy Theodore Neal · Lathrop, CAN2604YLawson Charles A · Arlington, WAN2605FRose Walter W · Arena, WIN2605GInnes Stephen L · Bentonville, ARN2606QElsayed Von Bayreuth Alaaeldeen Mohamed · Fairfield, CAN2607GJensen Rodney · Aptos, CAN2607SHunter Gary A · Fort Wayne, INN2607ZSidney Aviation LLC · Sidney, NEN2608JDriftless Aero LLC · Montfort, WIN2608QMiller David C · Burlington, CTN2608RRegistered aircraftN2609GRegistration Pending · Grove City, PARegistration pendingN2609LHavertown Flyers LLC · Havertown, PAN2609QDawson Arden H III · Eagle Nest, NMN2609YHelvey Michael H · Sheridan, WYN260DFMatchbox Holdings LLC · Harrisonburg, VAN260PTPeterson Todd · El Dorado, KSN260RAUpward Aviation LLC · Tulsa, OKN260TGPickerel Enterprises LLC · Bennet, NEN2610GBas Part Sales LLC · Greeley, CON2610JTrotzke Samuel P · North Pole, AKN2610SGordon Daryl B · Bellevue, WAN2611FMccall Aviation LLC · Union Springs, ALN2611XHyannis Air Service Inc DBA · Hyannis, MAN2612QLabarre Ben A · Hayward, WIN2612SNixon Edward J · Collierville, TNN2612UNeu Aviation LLC · Benton, LAN2613FHowe Justin · Encampment, WYN2613JKoontz Jeffrey T · Phoenix, AZN2613LOzark Aviators Inc · Willow Springs, MO
Back to AD 97-01-13