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.
N814CBN814cb LLC · Dover, DEN814CVJam Zoom Yayos LLC · Manheim, PAN814DEDickinson Dennis D · St Pete Beach, FLN814DPWestern Antique Aeroplane & Automobile Museum · Hood River, ORN814FARivinius Sam · Danville, CAN814FKGlasswings Llp · Chanhassen, MNN814HAIasco Flight Training Inc · Redding, CAN814JMLake Country Lodge · Port Alsworth, AKN814KCMoes Keith C · Independence, ORN814MSteuk Patricia A Trustee · Middle Bass, OHN814MAHolder Airplane LLC · Greenville, SCN814MBBell Spencer P · Breckenridge, TXN814MMFerguson Charles · Daphne, ALN814MSJones Keegan L · Pendleton, ORFirst renewal noticeN814RReed Mackenzie · Princeton, TXN814RCCamelot Express LLC · Naples, FLN814RVWhisman Marc · Independence, ORN814TJMaiorana Anthony J · Clarkston, WAN814TWGeorge Walker Field Inc · Bedminster, NJN814WMLannom John Rusty · Lebanon, TNN81509Dr Craig D Bartruff Md Pc · Mccook, NEN8150ABnb Enterprises Inc · Erie, PAN8150DBush Pacer LLC · Watauga, TNN8150JVandelay Aviation LLC · San Diego, CAN8150PFritcher Michael S · Arlington, TXN8150UCarpenter Sheldon · Liberty Two, OHN8150WJames Anthony K · Lexington, NCN8150XThere And Back Again LLC · Yorktown, VAN8150YBok Hans · North Dartmouth, MAFirst renewal noticeN81514Soar Above Flight Solutions LLC · Englewood, TNN8151DWoods Brian S · Longview, TXN8151NSmitty 172 LLC · Rockford, MIN8151P63 Comanche LLC · Las Vegas, NVN8151WMcarter Fred D III · Kentwood, LAFirst renewal noticeN81525Wilcox Robert D Jr · Mccook, NEN8152PBordens Jacob R · Chatham, NJN8152WStokes Kade · Caraway, ARN81531Shroyer Timothy M · Los Altos, CAN8153CHelileasing Inc · Las Vegas, NVN8153NStacy Blackburn · Milton, FLN8153WClear Sky Aviation LLC · Oviedo, FLN8153YChandelle Flying Club · Austin, TXN8153ZFehily Patrick · Lavallette, NJN8154ABlanco Edward L · South Egremont, MAN8154JCarter Flygare Inc · Sacramento, CAN8154NArmosa Studios LLC · Franklin, TNN8154WBennink James · Spring Lake, MIN8154YRawson Aviation LLC · Collinsville, OKN81552Oestreich Bret M · Owasso, OKN8155EOneill Jon · Argyle, TX
Back to AD 87-10-06 R1