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.
N75909Martin Michael J · Anchorage, AKN7590JOhlman Matthew · Atlanta, GAN75917Abs Aviation · Lanham, MDN7591FFinger Lakes Soaring Club Inc · Dansville, NYFirst renewal noticeN7591GRochez Gerald A · Jensen Beach, FLN7591RRight Rudder Brothers LLC · East Point, GAN7591WBurin John · Durango, CON75922Phillips Lester L · Pahrump, NVN75925A&A Aviation LLC · Edinburgh, INN75926Owens Flight Training LLC · Lafayette, LAN7592JWalker David C · Elk City, OKN7592PStrobach Kristin K · Rib Lake, WIN7592RInternational Security Network Inc · Pahrump, NVN7592YClover Park Technical College · Lakewood, WAN7592ZBrain Paul W · Webster City, IAN75930Rivera Aniceto · Boonton, NJN75931Alston Russell R · South Jordan, UTN75938Fiedler Aviation LLC · Suffolk, VAN7593EFrench Robert J · Ferndale, WAN7593PWaitkus James M · Oak Park, CAN7593RPiasecki Christopher Andrew · Lemont, ILN7593YEpic Aviation Leasing LLC · Puyallup, WAN75942Ward Sharon A · Lago Vista, TXN75943Savage Island Airport (Vt15) LLC · Burlington, VTN75944Noll Gregory Lloyd · Watford City, NDN7594FPierschbacher Clifton A · Marysville, WAN75950West John T · Bulverde, TXN75955Belgarde Monte G · Butte, MTN75956Millennium Aviation Group LLC · Wallace, NCN7595JDykes Jeff · Riverside, WAN7595RTedeschi Steve · Irving, TXN7595W180 Inc · Shelby Township, MIN75967Ace Of Spades Aviation LLC · Las Vegas, NVN7596JN7596j LLC · Denver, CON7596RChocolaterie Ltd · Des Moines, IAN7596WSchaefer Hugh W · Merrick, NYN7596YRodgers Kevin M · Vacaville, CAN75971Price Ronald Anthony · Deer Park, WAN75972Aircraft Resource Center Inc · Lakeville, MNN75974733et LLC · Columbus, OHN75976Suburban Aircraft Leasing And Sales LLC · Sylvania, OHN7597PSpinks Matthew Robert · Clarkesville, GAN7597RGarces Carlos A · Springfield, VAN7597VMulligan Shawn P · Santa Rosa, CAN7597XPlain Company Ltd · Bloomfield Hills, MIN75982Schurr Frank J · Las Vegas, NVN75985Pitt Patrick L · Ephrata, WAN7598GGbc Leasing LLC · Gun Barrel City, TXN7598JShutt Ervin F · Bennettsville, SCN7598PBurton Channing L · League City, TX
Back to AD 87-10-06 R1