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.
N25469Silver Express Co DBA · Miami, FLN2546KSkywagon 1 LLC · Boynton Beach, FLN2546RStephani Timothy Michael · White Lake, WIN2546YAvquest LLC · Jonesboro, ARN25476Rf Aero LLC · Plainfield, ILN25477Mason Harold T · Hesperia, CAN2547GHiebert Franz · Seminole, TXN2547JNguyen Tu Tuan M · Euless, TXN2547LDavis Tyler · Laurinburg, NCN2547UCostanzo Richard L · Toms River, NJN25480Freeflight Aviation LLC · Allentown, NJN2548GWells Kenneth B · Fort Myers, FLN2548RHuertas Andrew · Van Nuys, CAN2548UAlt Alexander B · Lockport, NYN2548YColbert Robert R · Oroville, WAN25497Wings Over Texas Holdings LLC · Denton, TXN2549GBrooks Roger W · Fairbanks, AKN2549LSiemon Mark R · Belle Plaine, MNN2549YHerlihy Douglas · Denville, NJN254CMGatewood Crisp · Tifton, GAN254KMFowler Michael J · Golden Valley, MNN254NYAckerman Rachael K · Sauk Rapids, MNN254PBNicole Business Group LLC · Hooks, TXN254RAReynolds Darryl G · Wills Point, TXN254SWalker Curtis · Lake Havasu, AZN254TM56h LLC · St Simons Island, GAN254TSGiesbrecht Nolan R · Burns, ORN254WGMccauley Thomas I · Puyallup, WAN254WTClik Services LLC · Forestdale, MAN255Sunset Aviation LLC · Klamath Falls, ORN25502Hartman Dylin Erik · Ray City, GAN2550JBlackburn Richard L · Pendleton, ORN2550LWooten Craig J · Campobello, SCN2550RSmalldridge Jonathan D · Arcadia, CAN2550SGrewal Amritpal S · Stockton, CAN25514Renner Thomas J · Williston, NDN25517Suski Jeanne M · Tonawanda, NYN25518Prather David W · Cameron Park, CAN2551GDaum Cole C · Woodstock, GAN2551JPeraza Jalil · Oklahoma City, OKN2551RHendrix Casey W · Ennis, TXN25525Ferguson Carrie L · Palo Alto, CAN2552JRegistered aircraftN2552KRicci Harry A · Kokhanok, AKN2552LFirst Flight Corp · San Diego, CAN2552RHooper Jerald Ray · Parker, AZN2553GRegistered aircraftN2553QSanders William R Jr · Lafayette, CON2553RDepore Joseph E · Charleston, SCN2554KBelleair Aviation LLC · Clearwater, FL
Back to AD 97-01-13