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.
N18145Stlouis Aviation LLC · Miramar, FLN1814FAlpine Cable And Construction Inc · Grand Junction, CON1814VBeyer Leasing Co · Paw Paw, MIN18155Willis Nathan Eric · Broken Arrow, OKN18157Matz Robert D · Niles, MIN18159Beck Thomas G · Walled Lake, MIN1815MReim Rodney D · Enid, OKN1815ROsprey Island Lodge Inc · Eagle River, AKN18162Pruzek Richard L · Chippewa Falls, WIN18163Wings Aero LLC · Zeeland, MIN18164Cendejas Agustin · Chino, CAN18167Be Chara Niz Ar E · Columbia, MDN1816FMalcom Scott O · Toledo, WAN1816JWakefield Aircraft LLC · Cooperstown, NDN1816QS And E Airplane Company · Puyallup, WAN1816RArizona Game & Fish Dept · Phoenix, AZN1816YNicholas Thomas M II · Enid, OKN18171Isaacson Arthur T · Hillsboro, MON18173Bb Aero Works Ltd · Whitehouse, OHN18174Connell William J · Woodinville, WAN18177Hoffman Rick W · Elk River, MNN1817QJohnston Bernard D · Puyallup, WAFirst renewal noticeN1817RLfg Properties LLC · Portage, MIN1817XSale Reported · Roseville, MNSale reported, pending cancellationN1818Fulton Ricky L · Alex, OKN18180Woodward Aviation · Varnville, SCN18182Samaha Fadi · Point Roberts, WAN18189Jaam-A LLC · Matthews, NCN1818AMaas Nancy C · Redding, CAN1818RSideline Services LLC · Pearland, TXN18197C150 Holdings LLC · Newark, DEN18198Ohare Douglas K · Ainsworth, NEN18199Forthman Scott Chance · Miami, FLN1819QSchmidt Mark · San Jose, CAN1819XGrant Steven T · Sellers, SCN181ATNazario Rafael · Delray Beach, FLN181CPEighty1 Aviation LLC · Canton, GAN181DHWinkler Jeffery L · Brush, CON181EWoodhead Matthew E Trustee · Reno, NVN181JBBarrows Grayson J · Mcminnville, ORN181JMMccloy John S · Lakeland, FLN181NWitt Robert A · Anchorage, AKN181PKPacific Mission Aviation · Hagatna, GUFirst renewal noticeN181RBBeltz Richard R · Lehighton, PAN181RCWheeler Douglas N Trustee · Santa Fe, NMN181RDWoodcock Air LLC · Wilmington, DEN181RPCain Jeffrey B · Godley, TXN181STWagontrainer LLC · Kalispell, MTN181TTWilson James · Bagwell, TXN181TXAddie-Air Inc · Bridgeport, TX
Back to AD 97-01-13