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.
N7968NLiebman Peter M · North Reading, MAN7968WLoser Eric S Sr · Millville, NJN7968YMustang Aeronautics LLC · Chandler, AZN7969GHealsburg Aviation · Healdsburg, CAN7969NJohnson Robert B · Murrieta, CAN7969WN7969w LLC · Reno, NVN796AATechnical Education Services Inc · Virginia Beach, VAN796ABDrake Aerial Enterprises LLC DBA · Genoa, OHN796DBAnderson David E · Batesville, ARN796EPPrince Ellis C · Frierson, LAN796HAJatavallabhula Narasimha Sastry · Longview, TXN796HEErd Larry · Pompano Beach, FLN796NDUnd Aerospace Foundation · Grand Forks, NDN796SBJones Dana C · Clermont, FLN796SPOpensky Airways LLC · Los Angeles, CAN796THSanders Flight Training Center Inc · Jasper, ALN796TMBlack John E · Cocoa Beach, FLN796TSSchlatterer William F Jr · Maumelle, ARN796WWCrist Aviation Services LLC · Woodland, CAN7970GAmerican Patrols Inc · Midland, TXN7970HMcneill Steven H · Santa Fe, NMN7970SNelson Dennis D · Salem, ORN7970WFly In Helicopters LLC · Florence, SCN7971FJanes Christopher D · Columbia, KYN7971NStalford Tom G · Nicholson, PAN7971YRegistration Pending · Collierville, TNRegistration pendingN7972CJust Plane People LLC · Irvine, CAN7972GMinot Aero Center · Minot, NDN7972HAerospace Trust Management LLC Trustee · Wilmington, DEN7972MRegistration Pending · Merrimack, NHRegistration pending, pending cancellationN7972VDionisio John · West Covina, CAN7972WLewis Paul A · Palm Bay, FLN7973HMessinger Donald C · Wasilla, AKN7973NN7973n LLC · East Greenville, PAN7974NKrumwiede Keith C · Rosedale, INN7974WAnderson Dale · Corona, CAN7974YHughes Frank H · Hackberry, LAN7975NKatz Alan D · Fayetteville, NCN7975WVilimek Mark W · Milpitas, CAN7976LFarrell Michael · Rockwall, TXN7976WWaldt Matthew C · Las Vegas, NVN7977Sievers Raymond T · Kenosha, WIN7977BG&M Aircraft Inc · Wheat Ridge, CON7977HMmwbc LLC · Hamilton, MTN7977SMelkuti Attila J · Carlsbad, CAN7977VRanten Christopher D · Climax, MNN7977WMain Arthur Ryan · Delaware, OHN7977YSouthern Aircraft Consultancy Inc Trustee · Casper, WYN7978ACollins Stephen A · Erath, LAN7978CHalo Aviation LLC · Agoura Hills, CA
Back to AD 81-18-04 R2