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.
N830MOliver Firm Lc · Dexter, MON830MAFlying Technologies LLC · Wilmington, DEN830MCArmor Packaging Corp · Piedmont, SCN830MDMcelwee Glenda A · Lake City, FLN830PColeman Nathan R · Zephyrhills, FLN830PCSprowl Brian M · Millville, NJN830RCMartin Douglas J · Lutz, FLN830TCRegistered aircraftN830TNPrianti Paul J · Rockaway, NYN830UPixton Christopher T · Oregon City, ORN8310HPettit Brian K · Wshngtn Ct Hs, OHN8310PPremiere Aviation Inc · Concord, CAN8310WBennett Anthony W · Bradenton, FLN8310YRegistration Pending · Kansas City, MORegistration pendingN83113N83113 LLC · Liberty, NCN8311CProficient Computing Solutions Corp · Fernandina Beach, FLN8311FGregoire Brandon James Ernst · Orlando, FLN8311KEnt Flight Services LLC · Santa Margarita, CAN8311LSimpson Robert B · South Pasadena, CAN8311NMcallister Joshua R · Gig Harbor, WAN8311PDuckett Kristofer · Fairfield, CAN8311WAlford Charles Mikael · Meadow Valley, CAN8311YAj Air LLC · Cape Girardeau, MON83126Ttl Aviation LLC · Lexington, KYN8312AToro Aero LLC · Calabasas, CAN8312HAlameda Aero Club · Alameda, CAN8312PPerson Timothy Ivan · Lake Stevens, WAN8312TRobinson Helicopter Co · Torrance, CAN8312WGillen James A · Cornville, AZN83130Registered aircraftN8313ACarter Donald R Jr · Nebo, NCN8313EShevah Avi · New Milford, CTN8313PSpencer Cory · Mobile, ALN8313TBehnfeldt Barry W · Napoleon, OHN8313WLummus Brett D · Forney, TXN8313YUnusual Attitudes LLC · Bates City, MON8314BSchultens Robert R Trustee · The Dalles, ORN8314CR M W LLC · Florence, SCN8314KRed Dirt Retreat LLC · Colorado Springs, CON8314MDavid Ari C Esq Trustee · San Diego, CAN8314WWingsleasing LLC · Wichita, KSN8315HKing 90 LLC · Milwaukie, ORN8315MBurcin Michael H · Washington, PAN8315PSquawk Wv LLC · Morgantown, WVN8315RJnl Aviation LLC · Orlando, FLN8315WJg Aero LLC · Smyrna, DEN8315YGolden Compass Aviation LLC · Wilmington, DEN83160Mikeman Carl · El Cajon, CAN8316CUplands Aviation Management LLC · Mineral Point, WIN8316DMarinephoto Helicopter LLC · Rehoboth Beach, DE
Back to AD 87-10-06 R1