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.
N8814YTwin 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, CAN8816CNye Brian M · Independence, ORN8816JHuff 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, FLN8817YWiehl 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, MDN8818CHalligan Austin C · Sidney, NEN8818YSouthern Aircraft Consultancy Inc Trustee · Casper, WYN88191Brown Dennis K · Reno, NVN88194Registered aircraftN88196Speer Jon H · Bryan, OHN8819ETransition Aviation LLC · Hummelstown, PAN8819WBowen Donald M · Wasco, ORN881ACFly Twin Comanche LLC · Peoria, AZN881BBBittner Robert A · Pewaukee, WIN881BC125 LLC · Sandy, UTN881CDWestern Pilot Service Inc · Phoenix, AZN881DCGoldfarb Martin · Scottsdale, AZN881DSSeltman Jack A · Wichita, KSN881FTFlorida Institute Of Technology · Melbourne, FLN881GLActualized Business Solutions Inc DBA · California, MDN881GPPuckett Gregory N · Vesuvius, VAN881JBHammer Roger W · Seattle, WAN881JFGriffin Aviation LLC · Minneapolis, MNN881JRFinnegan Brian E · Waterloo, IAN881KBAero Quest LLC · Olive Branch, MSN881KEPorter Equipment Holdings LLC · Magnolia, TXN881LAAircraft Holdings LLC · Mesa, AZN881LSNichols John B · Mena, ARN881MAHunt William E · Helena, MTN881PUTrustees Of Purdue University · West Lafayette, INN881RDOrchard Richard W · Sagle, IDN881RVKeeslar David L · Sturgis, MIN881RWWilliams Summit LLC · Salmon, IDN881SPIllinois State Police · Springfield, ILN881TAMcgough Julie E · Red Oak, TXN881UJBurke Farm Management Service Inc · Waynesboro, GA
Back to AD 81-18-04 R2