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.
N189AROverstreet Investments Inc · Boonville, MON189CFRascher Lawrence · Pacific, MON189DCWorthan Gary T Trustee · Storm Lake, IAN189ERMustang Sally Aviation LLC · Camden, SCN189JAPapillon Airways Inc · Kirkland, WAN189MKS2ar Aviations LLC · Lantana, FLN189SElfdog Aviation LLC · New Franken, WIN189WMatta Figueroa Eduardo · Chapman, KSN189WHBonafide Investments LLC · Dover, DEN18ADEzs Flyers LLC · Bonduel, WIN18BBMuseum Of Flight Foundation · Seattle, WAFirst renewal noticeN18BKShandog Air LLC · Ashland, KYN18CDDorman Richard E · Mesa, WAN18CLAkro Attitudes Inc · Boynton Beach, FLN18DADye Paul C · Mcneal, AZN18DMRachal Randolph B · Taft, TXN18EBAll American Aviation LLC · East Helena, MTN18EGBoanco Inc · Lafayette, INN18FAFisher Russell D · Vacaville, CAN18FGShapiro David Ely · Brookhaven, GAN18HBBuermann Henry · Brookfield, VTN18HRJ & R Aviation LLC · Hamilton, OHN18HTTobler Niccolo Sunny · Anchorage, AKN18JAJahawk Leasing LLC · Sugar Grove, ILN18JLKlapmeier Alan · Iron River, WIN18KKKhalil Kal Mohamed · Bedford, TXN18MRMorey Airplane Co Inc · Middleton, WIN18NFR D Aviation LLC · Phoenixville, PAN18NJTennessee Dept Of Saftey & Homeland Security · Nashville, TNN18NMRrcm Air LLC · Hialeah Gardens, FLN18NRWonderful Pistachios & Almonds LLC · Lost Hills, CAN18NSGilberto Alfonso · Washington, NCN18PBStogner Terry W · Lamesa, TXN18PWPhenix LLC · Dayton, WAN18SBTroy Motz Construction Inc · Lincolnton, NCN18SGBennett Jeannette DBA · Joiner, ARFirst renewal noticeN18STYoung Shawna Hodges · Turlock, CAN18TN18t Ltd · Wilmington, DEN18TBCarlson Herb Trustee · Dana Point, CAN18TCAviotti Inc · Henderson, NVN18TKMcpherson Kathrynne Alexine Trustee · Twin Falls, IDN18TLCarey Nicolas J · Rosamond, CAN18VUVincennes University · Vincennes, INN18WLMiller Christopher M · Centreville, VAN18YZHightower Ronny · Blanchard, OKN18ZKHappy Cat Cay LLC · Coral Gables, FLN18ZPPierce Lestley R · Henderson, NVN19004N19004 LLC · Bend, ORN19005Riddell Scott A · Winchester, KYN1900UBismarck Aero Center · Bismarck, ND
Back to AD 97-01-13