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.
N9084FIsland Bound LLC · Dunedin, FLN9084MWinzenried Ryan A · Pedro Bay, AKN9084XWareh Nabil · Corona, CAN9085GHatley Ralph A · Eagle Creek, ORN9085MLee Aviation Group LLC · Fort Myers, FLN9085XCessna 182 LLC · Missoula, MTN9086ATaylor Scott G · Draper, UTN9086GWilcox Leo Morgan · Winnie, TXN9087GHigh Planes LLC · Carter, MTN9087TGuminsky Michael · Toano, VAFirst renewal noticeN9087XLane James T · Theodosia, MON9088ACox-Kuss Sarah Ann · Colorado City, TXN9088XFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVN9089HDavis Joseph S · Andalusia, ALN9089XSebec Aviation Services LLC · Willimantic, MEN908HPNiessner Steven A · Golden, CON908SCGomez Ryan Rene · Fort Worth, TXN908WAPea-Wayman Flight LLC · Daytona Beach, FLN9091CYoung Gregory S · Riverside, CAN9091HCampbell Raymond · Box Elder, SDN9091MFrisbee Dennis R · Denton, TXN9091TBeachy Daniel W · Council, IDN9092CAdirondack Aviators LLC · Peru, NYN9092HWinemiller Stevie Dale · Swifton, ARN9092XWharton Joel E · Millsboro, DEN9093GThomas Kent · Wilsonville, ORN9094GRicks Thomas C · San Carlos, CAN9094RPetecraft Aviation Services Inc · Plains, GAN90951Simard Maurice E · Windham, CTN9095MSchramm Dale · Toledo, WAN9095XTaylor William E Trustee · Waynesville, MON9096HCallaway Mary Ann · Homedale, IDN9096MRedd Charles H Jr · Wasilla, AKN9097AWard Daniel Wayne · Boonville, NCN9097GScharping Glenn Alan · Whitelaw, WIN9097MClark David T · Grand Rapids, MNN9097XMcmillin Charles R · Lynn, MIN9098AWestphal Keith H · Mazomanie, WIN9098X98x LLC · Caddo Mills, TXN9099CCasa Miguelita LLC · Santa Fe, NMN9099GRegistration Pending · Edmond, OKRegistration pending, pending cancellationN9099XSnow Sam L · Las Cruces, NMN909GBHead West Lake Operations LLC · Dubois, WYN909MRRipp Patrick L · Mineral Point, WIN909SKaluahine Fredstan · Lihue, HIN909VCSan Bernardino Community College District · San Bernardino, CAN90BCSkypilot Aviation Ltd · Mcmurray, PAN90CKHodack Steven J · Burton, MIN90DZPjm Aviation LLC · Labelle, FLN90FGDavies James W · Oostburg, WI
Back to AD 87-20-03 R2