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.
N93024Ward Air Inc · Juneau, AKN93025Kiesel Edward K · Juneau, AKN93027Indy Air LLC · Blaine, MNN93030Cathey Wacey D · Polson, MTN93033Kaval John P Jr · Duxbury, MAN93035Des Aircraft LLC · Marianna, ARN93039Dorris Michael R · Mccall, IDN9303AYaw David Oderkirk Trustee · El Dorado Hills, CAN9303GBenson Steve J · Keenesburg, CON9303RCanoe Bay Outfitters LLC · Chugiak, AKN9303TBaxter Patrick L · Frisco, CON9303UWestover Scott A · Anchorage, AKN9303XHawaiian Airlift Company Llp · Kihei, HIN9304HWischmeyer Matthew R · Hopewell Junction, NYN9304RShah Zahid · Santa Paula, CAN93050Wilson Thomas Henry III · Anchorage, AKN93052Pfm 2025 LLC · Lake Forest, ILN93055Moore Joshua M · North Pole, AKN9305BStar Aero LLC · Santa Teresa, NMN9305CLinn Michael A · Nisswa, MNN9306CKoehrer Ernie · Palmer, AKN9306GPaiva Rafael R · College Station, TXN9306HAnycomm Corp · Gold River, CAN93078Black Cat Aviation LLC · Centennial, CON9307CJrs Buena Vida LLC · College Station, TXN9307DAviatzone LLC · Fort Lauderdale, FLN9307GSchwaderer Delbert L · Stevensville, MTN9307HMoss Jon · Gridley, CAN9307YRader Drew · Avon, CON93082Schweiger Nathaniel A · Richland, WAN93085Hoffsette Dianna L Trustee · Saint Catharine, MON9308BKorn Antony · Chehalis, WAN9308CCameron Thomas J · Stanchfield, MNN9308GBoilermaker-Warrior Express LLC · Grosse Pointe, MIN9308X5p&P LLC · Glenwood Springs, CON93096Ngumba Andrew N · Long Beach, CAN93098Faeo John D · Wasilla, AKN9309GHagle Terry A · Niceville, FLN9309XRigsby R W · Salisbury, NCN9309YYecny Alan K · San Luis Obispo, CAN930ASA2g International LLC · San Juan Capo, CAN930GGelazin Paul J · Palm Harbor, FLN930JSDolphin Air LLC · Fairbanks, AKN930LFWanner Robin L · Lufkin, TXN9310BThrom Donald R · Parachute, CON9310DRegistered aircraftN9310GBaldwin James C · Fruita, CON9310HLilienthal Donald W · Cyrus, MNN93112Strack Air LLC · Yorba Linda, CAN93116Wichita Area Technical College · Wichita, KS
Back to AD 87-20-03 R2