AD 87-10-06 R1
Registered aircraft · 72,010
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-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.
N76KSSchroepfer Ken J · Pecatonica, ILN76LCHacienda Hills Skyhawk LLC · Laveen, AZN76LMPavlovich Martin · Menomonee Falls, WIN76LYYonge Laurie W Jr · Oklawaha, FLN76MBHolt Helicopter Inc · Uvalde, TXN76MLDunn Courtland E Jr · West Grove, PAN76MMRichardson John H · Monticello, NMN76NATri Flying Tigers Inc · Wilmington, DEN76NCDonald K Ashley · Bradenton, FLN76NKNaples Jet Management LLC · Naples, FLN76NNSale Reported · Middletown, OHSale reported, canceledN76NPCollins Shannan S · Justin, TXN76PFRodriguez Amable Omar · Hialeah, FLN76PPGround Effect Aviation LLC · Ogden, UTN76PQBoyd Benjamin L · Kila, MTN76PTMcmurtrey Michael · Farmington, MNN76RMMj Aero LLC · College Station, TXN76RSCocke James A · Clarendon, TXN76RVVandevort Lynn A · Manitowoc, WIN76RWThomas Allen C · Willow, AKN76SBAdams Simmie A · Bealeton, VAN76SHConrad Edgar · Mc Alpin, FLN76SLLarsh Steven S · Libby, MTN76SRTangipahoa Mosquito Abatement District # 1 · Hammond, LAN76SSNorth Texas Aeronautics LLC · Burleson, TXN76SWHendricks Blair · Charleston, SCN76TAAhlhorn Travis W · New Braunfels, TXN76TCCox Thomas R · Kirkland, WAN76TDWillmott Wilson R · Huntington Station, NYN76TJBais Tim · Escondido, CAN76TRSwaney Mark J · Oxnard, CAN76TXBrenner Kurt · Saint Ann, MON76VAHartzell Propeller Emp Flg Club · Piqua, OHN76VMSwartz Aviation Group LLC · Argyle, TXN76WLBuckel Joseph T · Ellison Bay, WIN76WNCorben David Meyer · Lafayette, INN76WPHowes Robert P · Belleview, FLFirst renewal noticeN76WWOakley James H · Spring Valley, CAN76YHose Jerry A II · Oregon, ILN76YBJames Marvin L · Scio, ORN76YDBeasley Charles A · Spencer, VAN7700ATim Whitfield Aviation Inc · Fairfield, NCN7700JLuke Motley IV · Sherman, TXN7700MWood Duck Loop LLC · Mooresville, NCN7700PBarber Chris · Toney, ALN7700WGleasman Steven J · Rockton, ILN7701AEdb Air Inc · Wilsonville, ORN7701DChrysler Sheldon A · Pueblo, COFirst renewal noticeN7701MHurt Roy DBA · Newark, OHN7701NN5746u LLC · Dover, DE
Back to AD 87-10-06 R1