AD 87-20-03 R2
Registered aircraft · 54,015
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:87-20-03-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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.
N8970VWinding Creek Aviation LLC · Snellville, GAN89718Schad Paul E · Gainesville, TXN8971MDixon Gary Lynn II · Ooltewah, TNN8971VGibson Aviation Services LLC · Hudson, WIN89721Propability One LLC · Daytona Beach, FLN89727Wings Over Texas Holdings LLC · Denton, TXN8972GDay & Night Plumbing & Heating LLC · Sidney, NEN8972VPearce Michael J · Phoenix, AZN8972XFoothills Aviation LLC · Buhl, IDN89735N89735 LLC · Stuart, FLN8973GGough John C · Gooding, IDFirst renewal noticeN8973VOcean Flyers LLC · Chatham, NJN89743Heavy Metal Air LLC · Farmingdale, NYN8974BWaller Steven M · Sterling, CON8974GPike Vincent I · Bagdad, AZN8974SRegistration Pending · Bentonville, ARRegistration pendingN8974XHarris Warren R · Mccleary, WAN89753Aerohead Planes LLC · Savannah, GAN8975VMauser James E · Zionsville, PAN89764South Aero LLC · Albuquerque, NMN8976GTeeray LLC · Mountain City, TNN8976SHattaway Laura C · Rossville, GAN8976TKumm John J · Clarkston, WAN89770Seals Richard W · Torrance, CAN8977TAllsup Delmar D III · Oakhurst, CAN89780Huffman Jacob M III · Burleson, TXN8979SFurtadobradley D · Lodi, CAN8979TNardi Patty K · Missoula, MTFirst renewal noticeN8979VAvel Aircraft Inc · West Chicago, ILN897AHAerospace Asset Holdings LLC · Wilmington, DEN89800Ballesteros Irlena · Glendale, CAN8980TN8980t LLC · Dallas, TXN8980VSweitz-Air Inc · Stewartstown, PAN89811Sky Warrior Flight Training Inc · Pensacola, FLN89812Fremont Aviation Inc · Fremont, NEN89815Pinnacle Aviation Services Inc · Encinitas, CAN8981TCharlie Tango LLC · Rapid City, SDN8981XBales Philip J · Chandler, AZN8982TLarson Lynn R · Casselton, NDN8982VHirsch John K Trustee · Gerald, MON8983BMcguire Zach T · Jasper, MON8983VMoon Reagan E · Bossier City, LAN8984BWhelchel Neil E · Joshua Tree, CAN8984XSkydive Florida Keys Inc · Summerland Key, FLN89859Hess Garrett J · Fullerton, CAN8985SOrganization Of Black Aerospace Professionals · Westchester, ILN8985TDonald V Johns Jr · Rush, CON8985XHill Jack · New Lenox, ILN89863Ruess Richard M · Anchorage, AKN89869Wings Over Texas Holdings LLC · Denton, TX
Back to AD 87-20-03 R2