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.
N2574Y9th Moon Enterprises LLC · Alpine, TXN25754Jet & Rotor Aviation LLC · Sacramento, CAN2575GAltes Matt · Mount Shasta, CAN2575JStein Gerald A · Tolar, TXN2575KSchlick David L · Poulsbo, WAN2575SDulin Morgan L · Midland, TXN2575VStone Tommy R · Jacksonville Beach, FLN2575YSky Unlimited · Portland, ORN2576LRiggin Flight Service Inc · Madison, SDN2576QHamilton Steve · Carson City, NVN2576YRowe John W · Glen Haven, CON25772Arnold Jonathan L · Warrensburg, MON25773Solberg Avn Co Inc · Whitehouse Station, NJN25775Van Es Mark E · Laredo, TXN25779Eads James · Saginaw, TXN2577JDelaney John T · Bangor, PAN2577LKim L Jensen · Enoch, UTN2577QSlingsby J Geoffrey · Rapid City, SDN2577RSchomaker Michael J · Pleasanton, CAN2577SHurt Randall L · Smithville, TNN2577ZMaynard Christopher J · Anchorage, AKN25785Iggy Enterprises LLC · Gig Harbor, WAN2578JRenewed Inc · Tekamah, NEN2578YBush James W · Skaneateles, NYN2579GMcglachlin Brandon E · Moundridge, KSN2579JMaatje Charles J · Egg Harbor City, NJN2579KSkywagon LLC · Sterling, AKN2579SMenagh Bret J · Fresno, CAN2579UHann Aviation LLC · Yuma, AZN257FK257fk LLC · Marathon, FLN257JDAntonini Vittorio · New York, NYN257JSDelaurentis Robert · San Diego, CAN257LMSsb Aviation LLC · Wasilla, AKN257RRegistered aircraftN257RAReynolds Darryl G · Wills Point, TXFirst renewal noticeN257SPAviatzone LLC · Fort Lauderdale, FLN25807Peabody Jeffery L · Vinemont, ALN2580GLei Puahi Inc · Klamath Falls, ORN2580JKingdom Air Corps · Sutton, AKN2581JStikeleather Fred A · Hiddenite, NCN2581KYsc Inc · Harvard, MAN2581VMink Stephen Earl · Walnut Creek, CAN2581YOverman Aviation LLC · Saint Louis, MON25820Sale Reported · Xxx, OKSale reportedN2582KSherman David B · Readfield, MEN2582LRichardson Michael Todd · Wilkesboro, NCN2582Q82q LLC · Glenwood, MDN2582RBergmann Robert A · Lake Placid, FLN25836Hillsboro Aero Academy LLC · Hillsboro, ORN2583GN2583g LLC · Madison, KS
Back to AD 97-01-13