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.
N150TNExecutive Wings LLC · Bolivar, TNN150TPChapman Harold C III · Belton, SCN150TVPlane Fun Inc Tr Trustee · Snellville, GAN150UCNate Abel Flying Club · Ft Worth, TXN150UKMarshall Christoper E · Boise, IDN150VShingle Knob LLC · Blythewood, SCN150VMRegistered aircraftN150VTFly Vermont LLC · Swanton, VTN150WNDombert Dylan D · Navarre, FLN150WTJenson Greg R · Pueblo, CON150WVBlack Star Aviation LLC · Round Rock, TXN150XPSilver Skies LLC · Henderson, NVN150YATrans Atlantic Flight Support · Middletown, DENon-citizen corporation, flight hours not reportedN1510GGmr Leasing LLC · Lincoln, DEN1510QOracle Aviation LLC · Omaha, NEN1510YEegle Corps Inc · Wilmington, DEN1511CBouton Vern H · Fairbanks, AKFirst renewal noticeN1512CMolek Jon · Warren, OHN1512FJordan S G · Wasilla, AKN1512QGroves Fenton A · Morrisville, NYN15138Lone Star Flight Museum · Houston, TXN1513CSteffen Thomas E · Decatur, TXN1514MVaquera Moises C · Orland, CAN1514QHudgens Andrew S · Lubbock, TXN1514VVanreeth James E · Washington Island, WIN1515CMountain Taildraggers LLC · Aspen, CON1515FCain Ronald A · Slidell, TXN1515QPalm Springs Air Museum Inc · Palm Springs, CAN1516CSpotorno John Alan · Redwood City, CAN1516QToth John R · Concord, CAN1516VAircraft Management Services Inc · Milton, FLN15178Gill Robert S · Woodinville, WAN1517EHeavy Metal Air LLC · Farmingdale, NYFirst renewal noticeN1517FSalter 11x LLC · Duluth, MNN1517UN1517u LLC · Mequon, WIN1518QMidwest Aero Restorations Ltd · Danville, ILN1518UN1518u LLC · Waukesha, WIN15194Mcgrath Kevin M · Cloquet, MNN1519CMinor Edward H · Gordon, NEN1519QRuppert Thomas E · Fairbanks, AKFirst renewal noticeN1519VBent Prop LLC · Inver Grove, MNN1519YHarrison Michael R · Woodbine, MDN151CLAircraft Structures International Corp · Enid, OKN151CTSky West Aviation Inc Trustee · Albuquerque, NMN151DABaumgarten Robert J · Mobile, ALN151EDBishop Patrick M · Reading, MAN151EGGadis Anthony J · Etiwanda, CAN151GWSale Reported · Avondale, COSale reported, pending cancellationN151KACook Christopher K · Wintersville, OHN151PBarth Brian W · Port Orange, FL
Back to AD 97-01-13