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.
N206SVBremmer Randy R · Whitewater, CON206SXLaughlin Audio Video Electric Inc · Santa Ynez, CAN206TDHomestead Helicopters Inc · Missoula, MTN206TTThorson Thomas R · Wasilla, AKN206TXBowler Ryan · Saint George, UTN206TZTeton Leasing LLC · Polatello, IDN206USKandle Douglas A · Boise, IDN206VTSend North · Anchorage, AKN206WBOffice Of Aviation Services · Boise, IDN206WDCritical 32 Degrees LLC · Milton Freewater, ORN206WPMorrison Richard Lee Trustee · Anchorage, AKN206WTSevere Clear Aviation LLC · Hagerstown, MDN206WWSouthern Seaplanes LLC · Osteen, FLN206XKennedy Benjamin · Boulder, CON206XLVaughn Chris · Decherd, TNN206XPAirborne Flyer LLC · Ashland, NHN206YARantzair Inc · East Wenatchee, WAN206YSPalmer Ronald Everett Trustee · Hopkington, NHN20706Ahf Investments LLC · Ruston, LAN20708Viersen Leonard J Trustee · Glennallen, AKN20709Superior Fresh LLC · Idaho Falls, IDN2070GAerobus LLC · Des Moines, IAN2070KRudy Schmitt · Brookshire, TXN2070XNrt LLC · Maple Valley, WAN20713Spradling Tommy G Jr · Campbell, TXN20714All American Aviation Services Inc · Wilmington, NCN20716Sargent Philip R · North Scituate, RIN2071GGroarke Michael J · Marion, MTN20725Smith James M · Burbank, WAN20729Di Ludovico Leonard P · Leetonia, OHN2072GMccullough Russell O · Carson, CAN2072QMeenk Regna L · Las Vegas, NVN2072SKelty Joel P · Portland, ORN20730Tantiyatyanon Preeda · Flagstaff, AZN20734Galegor Samuel T · Pleasant Hill, MON20735Porter H Tom · Columbia, MSN20738Acquafly Creation LLC · Apopka, FLN2073EGreat Lakes Air Ventures LLC · Mason, MIN2073GShepard Brothers LLC · Columbia, MSN2073RWindler Steven D · Owasso, OKN20740Registered aircraftN20742Iowa Lakes Community College · Estherville, IAN20743Eagles Flight LLC · Grove, OKN20745Van Wert County Regional Airport Authority · Van Wert, OHN2074AN2074a Aviation LLC · Sheridan, WYN2074QStuzenski Patrick E · Shoreham, NYN2074YLloyd Allan · Otter, MTN2074ZKelly John M · Gastonia, NCN20751Donovan John A W · Wellesley, MAN20752Thoft Matthew M · Wasilla, AK
Back to AD 97-01-13