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.
N7017WLong Matt · Watsonville, CAN7017YMccormick Royce DBA · Seminole, TXN7017ZZimmer Chris P · Upham, NDN7018DHoeksel Michael J · Poplar Grove, ILN7018GCape Aerial Tours Inc · Chatham, MAN7018QStockett & Assoc Ltd · Hattiesburg, MSN7018RMccauley Lauren M · Severance, CON7018WArnold Richard C · Fitchburg, MAN70196South Shore Flying Club Inc · South Weymouth, MAN7019BRed Baron LLC · Middletown, DEN7019DMeginnes Mark A · Tucson, AZN7019EShimek Mark S · Port Lavaca, TXN7019QYenser Thomas A · Kutztown, PAN7019RMidland Flyers LLC · Warrenton, VAN7019VA & L Aviation LLC · Little Falls, MNN701BPWings Over Texas Holdings LLC · Denton, TXN701CAMkc Aviation LLC · St George, UTN701DCBlack Cat Aviation LLC · Indianapolis, INN701DMPacific Fleet Aviation LLC · Rochester, NYN701DTWilliamson Flying Club Inc · Williamson, NYN701EAPratt Thomas · Muncie, INN701FASkylane Flyers LLC · Fort Mill, SCN701FLInternational Air Services Inc Trustee · Carson City, NVN701HBBlaire William C · Rch Palos Vrd, CAN701JGAerostar LLC · Newport Beach, CAN701KENorthern Jet Sales LLC · Port Saint Lucie, FLN701LYork Nancy Lu Executor · San Angelo, TXN701PCMiramon Peter C · Salem, ORN701PYVallala Dino D · Milton, WAN701RALaith Aviation LLC · Goose Creek, SCN701SDRescue Ministry Corp · Haines City, FLN701SPScandinavian Aviation Academy Inc · El Cajon, CAFirst renewal noticeN701SXEastman Douglas Frank · Thornton, CON701THSmoke Seen LLC · Farmingdale, NYN701WMB&B Aerospace LLC · Rosamond, CAN701YWHorwath Ricky N · St James City, FLN7020BCutler Frank W · Leona Valley, CAN7020QAufderheide Flying Service Inc · De Witt, ARN7020RJwe Aviation LLC · Sugar Hill, GAN7020WDavila Antonio · Cudjoe Key, FLN7020YMehrhoff Stanley E · Prairie Home, MON7021BNewby Michael E · Pingree Grove, ILN7021WRichardson Garrett W · Mason, MIN7021YShira William G · Savannah, GAN70220Perun Av LLC · Cliffside Park, NJN70225Southeast Flight Leasing LLC · Cumming, GAN70228Eagle Sky Patrol Inc · Deadwood, SDN7022BSibille Keith C · Griffin, GAN7022QChant Savanah B · Baggs, WYN7022VCjsm LLC · Winter Haven, FL
Back to AD 87-10-06 R1