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.
N2476RBascom Richard J Trustee · Elkhart, IAN2476UFive States Holdings LLC · Helena, MTN24773Grusy Norman D · Portland, ORN24775Cal Aggie Flying Farmers Inc · Davis, CAN2477GRamsey Stephen C · Aspen, CON2477RJohnson Michael W · Kensington, OHN24781Shaw Erin · Reno, NVN2478FSchad Paul E · Gainesville, TXN2478GGilliland Sandra K · Julian, NCN2478QAbraham Curtis L · Byron, WYN2478RWeber Alan M · Manteca, CAN2478UBraun Kevin J · Aberdeen, SDN2478XCrooked Lake Aero LLC · Hammondsport, NYN2478YHockenson Roy D · Auburn, WAN2479CTo The Wind LLC · Salmon, IDN2479LMoore Joseph A · Kingwood, WVN2479QPriest David E · Caldwell, IDN2479U2479u Aviation LLC · Fernandina Beach, FLN2479XKruse Interests LLC · League City, TXN2479YDmac Aircraft LLC · Savannah, GAN247APNorth Joseph · Cocoa, FLN247CBDream Machine Leasing LLC · Glenbrook, NVN247DLCentral Florida Flight LLC · Ocoee, FLN247EFNobles Vernon H Jr · Calabasas, CAN247GSHyannis Air Service Inc DBA · Hyannis, MAN247HPCalifornia Highway Patrol · Sacramento, CAN247JPSpirit Air Inc · Salmon, IDN247KMNorthern Lights Ventures LLC · Moose Pass, AKN247LWHailey & Harmony Enterprises LLC · Las Vegas, NVN2480GGassaway Mitchell E · Carrollton, TXN2480LStephens Ryan J · Dallas, PAN2480URaczynski Adam · Far Rockaway, NYN24816Graves James A Trustee · Norman, OKN2481CPippert Jim · Dysart, IAN2481GEaster Brett D · Enumclaw, WAN2481LGhaemmaghami Ommid · Mckinney, TXN2481REngh Robert G · Laurel, MTN2481UWilliams Jeremy · Searsport, MEN2481YFellers Farms LLC · Burlington, OKN2482CMiller Richard W · Bellingham, WAN2482LTrubowicz Maciej Piotr · Cornelius, NCN2482QFox John E · Boonville, CAN24831Bishop Darin R · Livermore, CAN2483FMiller Clinton J · Traverse City, MIN2483GLenox Mark W · Idaho Falls, IDN2483JWestern Pilot Service Inc · Phoenix, AZN2483QMarch Kenrick D · Kingwood, TXN2483RSkydive Twin Cities LLC · Baldwin, WIN2484CLejeune Aerial Applications LLC · Basile, LAN2484FJones William Ransom · Anchorage, AK
Back to AD 97-01-13