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.
N8811YHutchinson Douglas E · Cle Elum, WAN88124West Aviation Inc · Creston, IAN88128Moore John T · Ward, ARN8812BSale Reported · Missoula, MTSale reportedN8812DSowders Darwin G · Robinson, TXN8812EHeiman Flying Services LLC · Summerfield, KSN8812PRegistered aircraftN8812YSpain Air LLC · Dadeville, ALN88130Harper Clayton E · Seabrook, TXN88135Reed Aviation Inc · Iota, LAN8813CUlrich Helmut Wiegand · Satellite Beach, FLN8813KPrecissi Flying Service Inc · Lodi, CAN8813MMja Flight LLC · Justin, TXN8813NLangton Shane A · Boise, IDN8813PWolcott Kent E · Colorado Springs, CON8813WOntiveros Carlos E · Prescott, AZN88144Hitchens Steven · Conesville, OHN88149Cheshire Brad F · Flower Mound, TXN8814FBas Part Sales LLC · Greeley, CON8814JCarey H Dwain · Cheyenne, WYN8814NMarshall Lance A · Portland, ORN8814YTwin C 14y LLC · Cape Coral, FLN88156Wilcox Aerial Applications Inc · Tilden, NEN8815NJenkins Roger Clayton II · Plain Dealing, LAN8815UHendrickson Tyrel L · Chester, MTN8815YBauer Andrew J · Concord, NCN88161Jordan Jay S · Wasilla, AKN88165Becker Aaron S · Santa Cruz, CAN8816JHuff Roger A · Johnstown, OHN8816LWindy City Soaring Association · Hinckley, ILN88172Hughes Glenn D · Wrightsville Beach, NCN8817CSharon Ricky E · Roberta, GAN8817JMy Bird Is Bigger Than Yours LLC · Fort Myers, FLN8817PTei Corp · Kalispell, MTN8817YWiehl Thomas K III · Earlysville, VAN88181Oglesby Holdings LLC · Henrico, VAN88182Dachnowicz Peter A · Avon, CTN88184Delmolino Kevin R Sr · Walkersville, MDN88188Blair Keeley A · Erie, CON88189Ocean Aerial Ads Inc · Ocean City, MDN8818XBeech Bash In The Bluegrass LLC · Fort Myers, FLN8818YSouthern Aircraft Consultancy Inc Trustee · Casper, WYN88191Brown Dennis K · Reno, NVN88194Registered aircraftN8819ETransition Aviation LLC · Hummelstown, PAN8819PN8819p LLC · Boca Raton, FLN8819WBowen Donald M · Wasco, ORN881ACFly Twin Comanche LLC · Peoria, AZN881BBBittner Robert A · Pewaukee, WIN881CDWestern Pilot Service Inc · Phoenix, AZ
Back to AD 87-10-06 R1