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.
N8466BPaphos Airways LLC · Farmingdale, NYN8466CBaker Matthew T · Shipman, ILN8466EGoldstein Allan · Elk Grove Village, ILN8466HOsgood Richard E · Boscawen, NHN8466LWild Blue Yonder LLC · Lewes, DEN8466RCoffman Shane · Liberty, INN84678Elizabethtown Flying Service Inc · Elizabethtown, KYN8467BAthens Aero Club Inc · Athens, OHN8467DAlexander Sam · Fair Play, MON8467RHowe Phillip Brandon · Hendersonville, TNN84686Registered aircraftN84688Quad Cities Aero LLC · Bettendorf, IAN8468DBliss James B · Anchorage, AKN8468LMidstate Aviation 1 LLC · Owosso, MIN8468WTailwinds Inc · Clear Spring, MDN8468YStone D L · Arlington, TXN84695Pike Mark D · Victorville, CAN84699Skyknights Of Western Ky Inc · Calvert City, KYN8469DPeppel Tom · Big Lake, AKN8469HBolter Aviation Inc · Lewisville, TXN8469LZitko Philip R · Shelby, OHN8469TLally Thomas J · Manomet, MAN846AAAb Prop Plane I LLC · Metairie, LAN846BHSeher Jacob Scott · Reno, NVN846DLRodgers William B · Dearing, GAN846EAkland Konrad R · Missoula, MTN846LCWegner Scott A · Sugar Grove, ILN846LLLindner James F · Williamsburg, MIN846PAfonso Joseph · Wallkill, NYN846SPSky Cag LLC · Hermosa Beach, CAN846TCTexas State Technical College · Waco, TXN847Ultimate Resort Vacations Inc · Weston, FLN8470HRolf Aviation Leasing LLC · Buffalo, MNN8470PTricounty Inc · Garden City, KSN8470YAndrew Odean T · Willow, AKFirst renewal noticeN84717Worldwide Warbirds Inc · Heber City, UTN8471BJust Did It LLC · Tampa, FLN8471CC S & W Aviation Inc · Fall Branch, TNN8471DAce Drilling LLC · Johnson, KSN8471RWright Richard L Jr · Flower Mound, TXN8471SReigle Daniel F · Crown City, OHN8471TGorman Aviation LLC · Bartlesville, OKN84721Tail Aero Corp · Wilmington, DEN8472BTmstarservices LLC · Lewes, DEN8472DKennedy Jared W · Cordova, AKN8472WInfinite Air Center LLC · Albany, ORN8473BWrightsville Aviation Partners LLC · Wilmington, NCN8473CR K Air Ltd · Harrisburg, PAN8473DDillon Edward L · Anchorage, AKN8473EBeck Roger M Trustee · Goode, VA
Back to AD 87-10-06 R1