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.
N7969WN7969w LLC · Reno, NVN796AATechnical Education Services Inc · Virginia Beach, VAN796ABDrake Aerial Enterprises LLC DBA · Genoa, OHN796DBAnderson David E · Batesville, ARN796EPPrince Ellis C · Frierson, LAN796HEErd Larry · Pompano Beach, FLN796SBJones Dana C · Clermont, FLN796SPOpensky Airways LLC · Los Angeles, CAN796TMBlack John E · Cocoa Beach, FLN796TSSchlatterer William F Jr · Maumelle, ARN796WWCrist Aviation Services LLC · Woodland, CAN7970GAmerican Patrols Inc · Midland, TXN7970PStevens Jon A · Byron, MNN7970SNelson 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, NDN7972MRegistration Pending · Merrimack, NHRegistration pending, pending cancellationN7972WLewis Paul A · Palm Bay, FLN7973NN7973n LLC · East Greenville, PAN7974NKrumwiede Keith C · Rosedale, INN7974WAnderson Dale · Corona, CAN7974YHughes Frank H · Hackberry, LAN7975NKatz Alan D · Fayetteville, NCN7975PB&R Aircraft LLC · Wadsworth, OHN7975WVilimek Mark W · Milpitas, CAN7976LFarrell Michael · Rockwall, TXN7976WWaldt Matthew C · Las Vegas, NVN7977Sievers Raymond T · Kenosha, WIN7977BG&M Aircraft Inc · Wheat Ridge, CON7977SMelkuti 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, CAN7978NCalio Joseph · Red Hook, NYN7978PKozak Aeronautical Company · Wilmington, DEN7978YBurnett Philip B · Lamar, ARN7979NAtlantic Coast Conservancy Properties LLC · Jasper, GAN7979PSanders Bill H · Wichita, KSN797ACWoods Gregory W · Englewood, FLFirst renewal noticeN797BBKurt Aviation · Middleton, DEN797BCCranberry Outfitters LLC · Richwood, WVN797CLZuras Dean P · Gaithersburg, MDN797DCCrowder James D · Newport, TNN797DLRegistered aircraft
Back to AD 87-10-06 R1