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.
N1664RState Of Montana · Helena, MTN1664VBismarck Aero Center Corp · Bismarck, NDN1664YOleary Joseph · Richmond, VTN1666QRegistration Pending · Plymouth, MNRegistration pendingN1666VSkypark Inc · Wadsworth, OHN1667FVarner Properties LLC · Bristow, OKN1667MTen Mile Ranch Inc · Vale, ORN1668MRocky Mountain High Aviation LLC · Louisville, CON1668QBrunk Hubert J · Lincoln, NEN1668REdwards Air Force Base Aero Club · Edwards Afb, CAFirst renewal noticeN1668TKevu Aviators LLC · Maryville, MON1668UUngalik Syndicate LLC · Unalakleet, AKN1669Berardinelli Michael A · Meridian, IDN1669MC Y Transport LLC · Columbus, MNN1669QIvy James E · Alba, TXN166DGDg Air LLC · Oakland, TNN166JBEp Aviation LLC · Wynne, ARN166ZUsda Forest Service Fire & Aviation · Boise, IDN1670CAlaska Freight Services LLC · Fairbanks, AKN1670FTillamook Pilots Association · Tillamook, ORN1670MFirebird Aviation LLC · Tempe, AZN1670THyde Family Aviation LLC · Wilmington, DEN1670YMarshall Gregory A · Sauk Rapids, MNN1671QRegistered aircraftN1671RDavis Ronald L Jr · Soldotna, AKN1671YDavid Dahl · Shevlin, MNN1672EWichita Area Technical College · Wichita, KSN1672QHall Donna L · Pulaski, TNN1672RBriggs Donald L · Santa Barbara, CAN1672YSmith David W · Texarkana, TXN1673EHusband Thomas W · Bigfork, MTN1673FHopkins Ronald J · Salt Lake City, UTFirst renewal noticeN1673MBower Ashley R · Anchorage, AKN1673RGregory John F · Emmitsburg, MDN1673YLentz Gregory · Green Forest, ARN1674CFarwest Aviation LLC · Billings, MTN1674FPlane Nuts Aviation LLC · Livingston, LAN1674VAbraham Elizabeth J · Browntown, WIN1675MWenk Peter J · Ocala, FLN1676FBrunson Tim R · Gilmer, TXN1676RBlue Side Up LLC · Elbert, CON1676YGray Bryan · Colorado City, TXN16771Tintman Inc · Spokane, WAN1677CDavis Aero LLC · Incline Village, NVN1677RYarger Denim B · Laurel, MTN1678FHorne William D II · Oxford, MSN1678RPureflight Aviation Training LLC · Newberg, ORN1678TGabaldon Martin · El Paso, TXN1678ZLongmire Dale · Senoia, GAN1679FCrawford Anthony B · Hampton Cove, AL
Back to AD 97-01-13