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.
N1721RStecher Allan · Thornton, CON17221Gray Jimmie E · Punta Gorda, FLN1722CA G Sholton Co · Wasilla, AKN1722FLeone William T II · Canfield, OHN1722SShoemake Gregory Allen · Palmer, AKN17230Chase Melissa L · Port Orange, FLN1723BBoyko George · Tarpon Springs, FLN1723CDi Gangi Stephen S · Spokane, WAN1723MStahlman Richard D · Beaverton, ORN1723QScroggy Edward R · Louisville, KYN1723VRay Alan G · Oklahoma City, OKN1724CLentz Walter E · Duncan, OKN1724FWalters Todd J · Darwin, MNN1724KN1724ken LLC · Minocqua, WIN1724MDickehut Donna C · Cloverdale, INN1724PNighthawk N8231g LLC · Pompano Beach, FLN1724RBlue Eagle Aviation LLC · Azle, TXN1724THanna David B · Tonasket, WAN1724YYankee Flying Club Inc · Maple Grove, MNN17251Aurora 17 Holdings LLC · Aurora, ORN17256Smith Taylor C · Amarillo, TXN17257Johnson Ralph R · Roanoke Rapids, NCN17258Registered aircraftN1725CC Wolf Inc · Ord, NEN1725FWagner Harold D Jr · Hilltop Lakes, TXN1725MAirbach LLC · Irvington, KYN1725ZDavid B Curliss · Beavercreek, OHN17260Woodley Aerial Leasing LLC · Walnut, ILN17263Medbery Nathan J · Minto, NDN17266Stroup Trey C · Fort Pierre, SDN17267Munch James L · Aumsville, ORN1726RPetumenos Timothy J · Anchorage, AKN1727CCarr Richard A · Boulder City, NVN1727FWhetham Ed · Wilton, NDN1727QGlobal Flight Training Solutions Inc · Immokalee, FLN17281Martin Air LLC · Fort Wayne, INN1728CMasek Lawrence J · Cuyahoga Falls, OHN1728FLemmon Mark D · Heppner, ORN1728MAnderson Michael · Missoula, MTN1728QUnd Aerospace Foundation · Grand Forks, NDN1728RIcenogle Roger A · Inver Grove, MNN17291Region Flyers LLC · Valparaiso, INN17293Kieren Bryce J · Tucson, AZN17295Alaverdi Omeed · California, MDN17298Biller Luke A · Milton, DEN17299Sale Reported · Mobile, ALSale reportedN1729CN8969v LLC · Anchorage, AKN1729FAllmann Mark F Trustee · Kent, WAN1729YFlying Colors Airparts Inc · Leesburg, FLN172APocock Milne David · Cal Nev Ari, NV
Back to AD 97-01-13