AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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.
N92CPSlattery Richard E · Fountain Valley, CAN92DSBooty Bill · Idaho Falls, IDN92NAOneill Laurie A · Pinckney, MIN92RHCrabtree Nathan J · Boise City, OKN92RZSale Reported · Gold Canyon, AZSale reportedN9300XEdwards Karen Marie · Mcminnville, ORN9301XShaunkoe LLC · Merrill, ORN93020Red Leasing LLC · Juneau, AKN93022Red Leasing LLC · Juneau, AKN93023Ward Air Inc · Juneau, AKN93024Ward Air Inc · Juneau, AKN93035Des Aircraft LLC · Marianna, ARN9303AYaw David Oderkirk Trustee · El Dorado Hills, CAN9303GBenson Steve J · Keenesburg, CON9303RCanoe Bay Outfitters LLC · Chugiak, AKN9303TBaxter Patrick L · Frisco, CON9303XHawaiian Airlift Company Llp · Kihei, HIN9304RShah Zahid · Santa Paula, CAN93052Pfm 2025 LLC · Lake Forest, ILN9305CLinn Michael A · Nisswa, MNN9306CKoehrer Ernie · Palmer, AKN9306GPaiva Rafael R · College Station, TXN9307CJrs Buena Vida LLC · College Station, TXN9307GSchwaderer Delbert L · Stevensville, MTN9307HMoss Jon · Gridley, CAN9307YRader Drew · Avon, CON9308CCameron Thomas J · Stanchfield, MNN9308GBoilermaker-Warrior Express LLC · Grosse Pointe, MIN9308X5p&P LLC · Glenwood Springs, CON9309CVan Bortel Aircraft Inc · Arlington, TXN9309GHagle Terry A · Niceville, FLN9309XRigsby R W · Salisbury, NCN9309YYecny Alan K · San Luis Obispo, CAN930CPCivil Air Patrol · Maxwell Afb, ALN930GGelazin Paul J · Palm Harbor, FLN930LFWanner Robin L · Lufkin, TXN9310GBaldwin James C · Fruita, CON93112Strack Air LLC · Yorba Linda, CAN9311GSooter Craig · Blue Ridge, TXN9311TCrouse John A · Sterling, AKN9311XLink Lance L · Concordia, KSN93128High Plains Aero Consulting Inc · Pampa, TXN93129Klca Inc · Warsaw, INN9312ARudisel Kenneth J · Williamsburg, MIN9312GYoung Robert S IV · Abilene, TXN9312XLewan William F · Naperville, ILN93135Shannon Frances W · Clarksdale, MSN9313XSjb Farms LLC · Albany, ORN9314CThielker Mark Robert · Bellaire, TXN9314GPeerbolte John K · Highland, IN
Back to AD 84-10-01 R1