AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.
N814PDHoward Michael Q · Peachtree City, GAN814RReed Mackenzie · Princeton, TXN814RCCamelot Express LLC · Naples, FLN814RVWhisman Marc · Independence, ORN814SAMarion Military Institute · Marion, ALN814SBLyddon Steven R · Liberal, KSN814TJMaiorana Anthony J · Clarkston, WAN814TWGeorge Walker Field Inc · Bedminster, NJN814URotor Leasing LLC · Indianapolis, INN814WMLannom 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, TXN8155GSaraceno Robert Jr · Lynnfield, MAN8155HPeckerhead Motorcycle Racing LLC · Gainesville, GAN8155NThompson Trent A · Forsyth, MTN8155PSanders Tyler George · Tehachapi, CAN8155WCochran William J · Williamson, GAN8156DMoyle Matthew L · Soldotna, AKN8156NMoreau Donald G · Dayton, TXN8156PVectors West LLC · Coeur D Alene, IDN8156RGhazarian Christopher L · North Hollywood, CAN8156TAzcona Rogelio G · Okeechobee, FL
Back to AD 81-18-04 R2