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.
N18524Alpha International Aircraft Inc · Lewes, DEN18527Bundy Richard S · Little Egg Harbor, NJN18529Briers Scott Kevin · Conroe, TXN1852EMarshall Dennis Ray Jr · Pottsboro, TXN1852FSymbot Management Inc · Dover, DENon-citizen corporation, flight hours not reportedN1852QTalbot Mitchell R · Queen Creek, AZN1852RHartman Craig T Trustee · Chugiak, AKN1852XPhillips Lane · Dawson, TXN1852YMinot Light Aviaiton LLC · Rockland, MAN18531National Test Pilot School · Mojave, CAN18533Booth Donald V · Denison, TXN18534Rupert Dinah J · New Plymouth, OHFirst renewal noticeN18537Kirsch Richard D · Lisbon, NDN1853QSend North · Anchorage, AKN1853YHurd Roger Mark · Bow, WAN18540Fisher Tracey R · Glenwood, IAN18546O'Sita Tade · Burnsville, MNFirst renewal noticeN1854FHarlan Bradley J · New Brighton, MNN1854QSc Cardinal LLC · Wilmington, DEN1854VSchmitt Rudy · Brookshire, TXN1854YMikowski Charles A · Sparta, MIN1854ZBargabos William M · Wasilla, AKN18552Malecha James L Trustee · Wilmot, NHN18554Lavelle Jonathan A · Berrien Springs, MIN18558Gunderson Robert B · League City, TXN18565Hughes Danny R · Hickory, NCN18567Barros Da Silva Norton · Tyler, TXN18568Green Tom H · Vega, TXN18569Doyle Harley M · O Brien, FLN1856QEmpty Hanger LLC · Traverse City, MIN1856RRich Gary L · Anchorage, AKN1856XRobert Yost Enterprises · Saint Francis, KSN18572Stofka Joseph M · Erie, MIN18574Reed Philip D · Millsboro, DEN18576Cardinal-Bird LLC · Melbourne, FLN18578Nauerth John III · Lakefield, MNN18579Beck Roger M Trustee · Goode, VAN1857RNoetic Aviation LLC · Seattle, WAN1857VCare Central Inc · Minneapolis, MNN1857YKnudson Wayne L · Larimore, NDN18580Kirk Bryan · Las Vegas, NVN18582Voigts Bruce M · Clarion, IAN18583Niles Donald W · Wadena, MNN18584Murphey Julian Ryan · Knoxville, TNN18586Flyit LLC · Camas, WAN18587Payne Frederick B · Fayetteville, GAN1858MCrowley Michael A · Wake Forest, NCN1858QScott Air LLC · Cave Creek, AZN1858XSalem Aero Club Inc · Bridgeton, NJN1858YBlaich George F IV · Poplar Bluff, MO
Back to AD 97-01-13