AD 87-17-01
Registered aircraft · 905
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-17-01')
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-17-01')
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-17-01') 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-17-01') 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.
N1164SConnecticut Soaring Association Inc · New London, CTN1166SBlanton Robert D · Wichita, KSN1167SKite Adam H · Ogden, UTN1169SCypress Soaring Inc · Hemet, CAN1170SRefugio Soaring Circle Inc · Refugio, TXN1172SValley Soaring Club Inc · Middletown, NYN1173SFlint River Soaring LLC · Bainbridge, GAN1176SSky Sailing Inc · Warner Springs, CAN1179SSchwam Julie R · Hayden, IDN1182SDouglas Paul W · Brooklyn, WIN1184SBates Marcus L · Leander, TXN1185SFault Line Flyers · Leander, TXN1186SMohawk Soaring Club · Hoosick Falls, NYN1187SAir Biscuit LLC · Williamson, GAN1188SFault Line Flyers · Leander, TXN1189SSkysurfing Hawaii LLC · Waialua, HIN1190SSky Sailing Inc · Warner Springs, CAN1191SCivil Air Patrol · Maxwell Afb, ALN1196SBlack Industries LLC · Helena, MTN1200SRetroair Restoration LLC · Big Lake, AKN1226GWest Michigan Aviation Academy · Grand Rapids, MIN1227SKutztown Aviation Service Inc · Germansville, PAN1228SConnecticut Soaring Association Inc · New London, CTN1229SBurbank Franklin R · Ocala, FLN1232SN292 Ac Flyers LLC · Brandon, MSN1233SIroquois Soaring Association · Rome, NYN1239SSky Sailing Inc · Warner Springs, CAN1242SNew England Soaring Association · North Springfield, VTN126AOliver John F Trustee · Chula Vista, CAN126BWilkinson Ephriam B · Eads, TNN126BAAnderson Austin R · Capitan, NMN126BVCollins Dennis L · Richland, WAN126CPHamilton Soaring Club Inc · Hamilton, TXN126CRMhr Leasing LLC · Hickory Corners, MIN126DDungan Gregory David · Boca Raton, FLN126DBBlack-Nixon C Dianne · Wayne, NJN126EWilkinson Ephriam B · Eads, TNN126ERHobbs Martin Lowell · Old Fort, NCN126HDMahony Thomas Charles · Mcmurray, PAN126HWCooper Remel R Jr Trustee · Green Cove Springs, FLN126JLErnst Daniel D · Poquoson, VAN126MDGrand Lake Air Ventures LLC · Celina, OHN126MHSky Sailing Inc · Warner Springs, CAN126MNStanton Sport Aviation · Stanton, MNN126NKRegistered aircraftN126RMSteinmetz Peter N Trustee · Tempe, AZN126SFGrace Lance C · Alamogordo, NMN126SGLowry Wilson R · Leonardtown, MDN126TDOliver Thomas M · Littlefield, AZN126TULeroy Philippe G · Willcox, AZ
Back to AD 87-17-01