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.
N8308LClassic Wings · Westlake Village, CAN8308MGfl Aircraft Leasing Corp · Glens Falls, NYN8308RClassic Flyers Club Inc · Hastings, NEN8308WSchlenker Richard A · Meeteetse, WYN8309ASchmidtys Air LLC · Stuart, FLN8309EPlanewright Inc · Newberg, ORN8309KClaridge Michael A · Houston, TXN8309RPipal Cory J · Dublin, TXN8309VSunde Bradley J · Fergus Falls, MNN8309YHolman Michael J · Anchorage, AKN830ADb-Gbr LLC · Sarasota, FLN830AKOld City Helicopter Sales LLC · Saint Augustine, FLN830BMurphys Auto Gyro Sales LLC · Dade City, FLN830BSShortt Aircraft Leasing LLC · Wilmington, DEN830BVRegistration Pending · Manhattan, MTRegistration pendingN830CPCivil Air Patrol · Maxwell Afb, ALN830JVeracity Aviation LLC · Seguin, TXN830KXHillsboro Aero Academy LLC · Hillsboro, ORN830LMKq Aviation LLC · Old Town, FLN830MOliver Firm Lc · Dexter, MON830MAFlying Technologies LLC · Wilmington, DEN830MDMcelwee Glenda A · Lake City, FLN830MUMarshall University · Huntington, WVN830PColeman Nathan R · Zephyrhills, FLN830PCSprowl Brian M · Millville, NJN830RCMartin Douglas J · Lutz, FLN830TCRegistered aircraftN830TNPrianti Paul J · Rockaway, NYN830UPixton Christopher T · Oregon City, ORN830ZCartwright John P · Watkinsville, GAN8310HPettit Brian K · Wshngtn Ct Hs, OHN8310WBennett Anthony W · Bradenton, FLN8310YRegistration Pending · Kansas City, MORegistration pendingN83113N83113 LLC · Liberty, NCN8311FGregoire Brandon James Ernst · Orlando, FLN8311LSimpson Robert B · South Pasadena, CAN8311PDuckett Kristofer · Fairfield, CAN8311WAlford Charles Mikael · Meadow Valley, CAN8311YAj Air LLC · Cape Girardeau, MON83126Ttl Aviation LLC · Lexington, KYN8312AToro Aero LLC · Calabasas, CAN8312HAlameda Aero Club · Alameda, CAN8312PPerson Timothy Ivan · Lake Stevens, WAN8312TRobinson Helicopter Co · Torrance, CAN8312VPester Mark C · Crookston, MNN8312WGillen James A · Cornville, AZN83130Registered aircraftN8313ACarter Donald R Jr · Nebo, NCN8313EShevah Avi · New Milford, CTN8313TBehnfeldt Barry W · Napoleon, OH
Back to AD 81-18-04 R2