AD 85-02-05 R1
Registered aircraft · 8,920
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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.
N5064CEaton Roger C · Vernon, NYN5064ZGregory Trace D · Springfield, MON5065PVeal Ted W · Homer, AKN5066PDelaware Aviation LLC · Sidney, NYN506JMAims Community College · Greeley, CON5070ZMoser Gary A · Van Wert, OHN5071YFletchers Aviation LLC · Mason, NHN5072ZMunning Doris E Trustee · Sellersburg, INN5074PShingledecker Robert K II · Ozark, ARN5075ZConstantine Stephen B · Anchorage, AKN5076ZBottoms Michael L · Danbury, NCN5078PPutnam Andrew L · New Limerick, MEN5078ZPierce Justin P · Conifer, CON5079YDiaz Apolo · Kansas City, MON5079ZJohnson Sappa Farms LLC · Stamford, NEN507JBDi Marco Michael G · Orlando, FLN5080ZBrazil Joshua B · Omaha, NEN5081YDoumis Joy S · Marathon, FLN5081ZTech Mobile LLC · New Windsor, MDN5082YTanner Greg · Bend, ORN5082ZHuddleston Anthony A · Knoxville, TNN5083ZMorell Patrick J · Byron Center, MIN5086ZRichards Curtis A · Troy, MON5088CMike Golf Holdings LLC · Pinellas Park, FLN5088PKesser Gilbert M · Culpeper, VAN5088ZDavis Scott A · Bingham, NEN5089YLewis Aaron J · Salado, TXN5091PSpicuzza Robert A · Waterford, MIN5093PAir Chutney LLC · Waynesboro, VAN5093ZSelby Gerald A · Sand Springs, OKN5094ZDugan Garry P · Manvel, NDN5097YBlackburn Anthony C · Mcdonough, GAN5098ZHanlon Ronald J · Seattle, WAN5099PSelinger Richard L · Murrieta, CAN5099ZKaufold E Richard · Ridge, NYN509GCN509gc LLC · Branford, CTN50CCScott Macdonald Aircraft Sales Inc · Stuart, FLN50CSBoretsky Bryan F · Lolo, MTN50GFHarrington Brian · Fountain Inn, SCN50JTRiba Scott S · Montrose, CON50TDPa-30 LLC · Appleton, WIN50TPSoar Utah Inc · Heber City, UTN5100PHuntcliff Air Services LLC · Atlanta, GAN5100ZLawrence Richard J · Wooster, OHN5102YK F Aviation Inc · San Juan, PRN5103Z92nd West Aviation Inc · Lonoke, ARN5104ZGary L Morton · Palmer, AKN5105ZKrumm Melvin L · Allegan, MIN5106ZDorsey James P · Bainbridge Island, WAN5107PStranton Air LLC · Harvard, IL
Back to AD 85-02-05 R1