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.
N8424LMcgreen John R · Albany, NYN84250Wick James R · Canon City, CON84256Registered aircraftN8425FSons Aviation LLC · Moody, ALN8425HJohansen Herbert J · Bennington, NEN8425PSaratoga 25 Papa LLC · Carmel, INN8425TN93lv LLC · Lancaster, PAN8425WBenner James R · Goshen, INN84263Chadwick James B · Rch Palos Vrd, CAN84265West Gerald Lee · Two Harbors, MNN84267Shields Debra M · York, SCN8426CHarper-Smith Michael · Tarzana, CAN8426POta Paul T · Grayslake, ILN8426RBryant Bryce E · Evans City, PAN84271Anderson Operations LLC · Fallon, NVN84275Rodriguez Norberto R · Inwood, NYN84278Ap Air LLC · Wilmington, NCN8427CMorgan Aviation LLC · Greensboro, NCN8427DEastin Toby M · Jefferson City, MON8427EJc Aviation Inc · St Simons Island, GAN8427GWarrior II Ltd · Des Plaines, ILN8427KInternational Air Services Inc Trustee · Carson City, NVN8427RLopez Trinidad V · El Cajon, CAN8427TPierce Rex G · Shorewood, ILN8427WKsiezyk Donald G · Wadsworth, OHN8427YBiernacki David F · Rockford, ILN84285Paquin James R · Orangeburg, SCN84289Angelov Ruslan P · Mount Prospect, ILN8428BHiggins James · Oxford, NCN8428DMullen Samuel J · Fairbanks, AKN8428HWilson Jessica D · Gallipolis Ferry, WVN8428PBertling Kevin M · Spring, TXN8428SLand O Lakes Flying Club Inc · Bloomfield Hills, MIN8428WAces High Aviation LLC · Casper, WYN84293Nwa Flyers LLC · Missoula, MTN84299Phoenix Aviation Holdings LLC · Crystal Beach, FLN8429DDickson Wayne K · Luthersville, GAN8429NSeybert Daniel P · Anchorage, AKN8429WCleveland Tommy E · Mountain View, ARN8429XLinville Manor LLC · Reidsville, NCN842ACSummit Aeronautics LLC · Dania, FLFirst renewal noticeN842BJMaster Trade LLC · Detroit, MIN842CSSomerville James P · Anchorage, AKN842DBBrons Lawrence C · Canby, ORN842DKDemiris William P · Westbrook, CTN842KZPowell Michael Brandon · Murfreesboro, TNN842LBBlair Lynward E · Headland, ALN842LPJet Air Inc · Iowa City, IAN842MM43 Northstar LLC · Dodgeville, WIN842NEPringle Greg S · Sandy, UT
Back to AD 87-10-06 R1