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.
N20HTRed Arrow Aviation LLC · Santa Teresa, NMN20JNGana Trucking & Excavating Inc · Martell, NEN20JSOyaski Michael F · Ebensburg, PAN20MUOracle Aviation LLC · Omaha, NEN20MWStriebel David J · Dayton, OHN20NGTas Aviation Of Defiance Inc · Defiance, OHN20RHStoltzfus John F Jr · Strasburg, PAN20RSStendal Russell M · Hollywood, FLN20VKEvans Jeffrey L · Mansfield, LAN20WAOn Air Company LLC · Sewickley, PAN20WFLofton Christopher L · Harlingen, TXN20WGBingham James H · Dillingham, AKN20WMMcdonald John P · Kennewick, WAFirst renewal noticeN21000Yunger John C · Newton, WIN21001Global Acquisitions Ltd · Davenport, IAN21004M & J Aviation LLC · Clarkston, MIN21006Lerma Gilbert L Sr · Salome, AZN21009Law Jonathan · Davis, CAN2100FDurocher David T · Fernley, NVN2100GTpa Skylane LLC · Asheville, NCN2100RAbresch Craig G · Idaho Falls, IDN2100ZGreenwood Stephen · Salt Lake City, UTN21010Mikiewicz Joseph · West Pittston, PAN21013Thompson Jack M Jr · Ithaca, NYN21014C & G Aviation LLC · Hollandale, MSN21015Renfro Michael W · Bethel, AKN21017Eastern Idaho Flying Club LLC · Idaho Falls, IDN2101EV1 Aviation LLC · Englewood, CON2101XScofield Bruce W · Batavia, NYN21020Monteiro Armando D · Stratford, CTN21024Horlick Harlan C · Crossville, TNN21028Snflk Leasing LLC · Andrews, TXN2102EBrooks Terry A · Shelby, NCN2102FOlson Tim O · Saint Onge, SDN2102GPool Lori A · Cody, WYN21034Luxford Richard L · Los Angeles, CAN21035Hayes Bradley M · Grove, OKN21036Nace Kris A · Glendale, ORN21037Registration Pending · Boulder City, NVRegistration pendingN21038Mindy Limited LLC · Muscatine, IAN2103SSan Diego Flight Corp · San Diego, CAN21043Registration Pending · Hemet, CARegistration pendingN21047Sessoms Marcus · Key West, FLN2104FBrown Steven R · Soldotna, AKN2104RRegistration Pending · Palm Beach Gardens, FLRegistration pendingN21055Harty Timothy L · New Richmond, WIN21059Poe David P · Rockville, MDN2105FClik Services LLC · Forestdale, MAN2105QBarreto Daniel · Enterprise, ALN2105SSouthport Aviation LLC · Cape Coral, FL
Back to AD 97-01-13